自定义函数

mysql:

SELECT getxldcScore('很轻'); 

drop function getxldcScore
CREATE FUNCTION getxldcScore (arg1 VARCHAR(255))
RETURNS INT
BEGIN
    DECLARE result INT;
		
			IF arg1 ='没有' THEN
			 SET result = 1;	
		  ELSEIF arg1 ='很轻' THEN
			SET result = 2;	
			ELSEIF arg1 ='中等' THEN
			SET result = 3;	
			ELSEIF arg1 ='偏重' THEN
			SET result = 4;	
			ELSEIF arg1 ='严重' THEN
			SET result = 5;	
			ELSE
			SET result = 0;
      END IF;
			RETURN result;
END;