Mega Code Archive

 

Categories / MySQL Tutorial / Control Flow Functions

 

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>