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

Use LIKE BINARY:

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

mysql sql case-sensitive sql-like

Another alternative is to use COLLATE,

SELECT *FROM table1WHERE columnName like 'a%' COLLATE utf8_bin;

CodeHunter