Function MySQL

  1. Home
  2. MySQL
  3. Function
  4. 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)