Mega Code Archive

 

Categories / MySQL / Function

 

Using the comparison value form of CASE WHEN

mysql> mysql> SELECT CASE 3 WHEN 1 THEN "One" WHEN 2 THEN "Two" ELSE "Three" END; +-------------------------------------------------------------+ | CASE 3 WHEN 1 THEN "One" WHEN 2 THEN "Two" ELSE "Three" END | +-------------------------------------------------------------+ | Three                                                       | +-------------------------------------------------------------+ 1 row in set (0.00 sec)