Control Flow Functions MySQL Tutorial

mysql>
mysql> SELECT CASE BINARY 'B'
    ->        WHEN 'a' THEN 1
    ->        WHEN 'b' THEN 2
    -> END;
+---------------------------------------------------------------------+
| CASE BINARY 'B'
       WHEN 'a' THEN 1
       WHEN 'b' THEN 2
END |
+---------------------------------------------------------------------+
|                                                                NULL |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>