CASE with case-sensitve comparison : CASE : Control Flow Functions MySQL TUTORIALS

MySQL TUTORIALS » Control Flow Functions » CASE »

CASE with case-sensitve comparison


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>