MySQL Documentation 13.6.5.1 CASE Statement
CASE case_value
WHEN when_value THEN statement_list
[WHEN when_value THEN statement_list] ...
[ELSE statement_list]
END CASE
Or:
CASE
WHEN search_condition THEN statement_list
[WHEN search_condition THEN statement_list] ...
[ELSE statement_list]
END CASE
MySQL Documentation 13.6.6 Cursors
MySQL Documentation 13.6.7.1 DECLARE ... CONDITION Statement
MySQL Documentation 13.6.7.2 DECLARE ... HANDLER Statement
MySQL Documentation 13.6.5.2 IF Statement
IF search_condition THEN statement_list
[ELSEIF search_condition THEN statement_list] ...
[ELSE statement_list]
END IF
DELIMITER //
CREATE FUNCTION SimpleCompare(n INT, m INT)
RETURNS VARCHAR(20)
BEGIN
DECLARE s VARCHAR(20);
IF n > m THEN SET s = '>';
ELSEIF n = m …MySQL Documentation 13.6.5.5 LOOP Statement
MySQL Documentation 13.6.5.6 REPEAT Statement