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 |