UDF(User Define Function), Delimiter

 

DELIMITER //

CREATE FUNCTION isStrong(attack INT, defense INT)
RETURNS VARCHAR(20)
BEGIN
DECLARE a INT;
DECLARE b INT;
DECLARE isstrong VARCHAR(20);
SET a = attack;
SET b = defense;
SELECT CASE
WHEN a+b>120 THEN 'very strong'
WHEN a+b>90 THEN 'strong'
ELSE 'not strong'
END INTO isstrong ;
RETURN isstrong;
END

//
DELIMITER ;


SELECT name, isStrong(attack, defense) AS isStrong
FROM mypokemon;