CASE with case-sensitve comparison : CASE « Control Flow Functions « MySQL Tutorial

1. MySQL Tutorial
2. Control Flow Functions
3. CASE

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>
mysql>