How do you force mysql LIKE to be case sensitive? [duplicate]

January 5, 2023 by Tarik

Use LIKE BINARY:

mysql> SELECT 'abc' LIKE 'ABC';
    -> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';
    -> 0