Mega Code Archive

 

Categories / MySQL / String

 

Case-insensitive nature of string comparisons

mysql> mysql> SELECT 'abc' = 'ABC'; +---------------+ | 'abc' = 'ABC' | +---------------+ |             1 | +---------------+ 1 row in set (0.00 sec)