String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. String comparisons are not case sensitive unless one of the operands is a binary string
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>