MENU


Flow Control

SELECT CASE 2 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'three' END; two
SELECT CASE WHEN 1 = 2 THEN 'first' WHEN 2 = 2 THEN 'SECOND' ELSE 'THIRD' END;
-- first TRUE result		 SECOND
SELECT IF(5<8, 'smaller', 'greater'); smaller
SELECT IFNULL(5,'abc'), IFNULL(NULL, 'abc'); 5 abc
SELECT NULLIF(10,10), NULLIF(9,10); NULL 9