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