To specify a different escape character, use the ESCAPE clause: : LIKE « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. LIKE
mysql>
mysql> SELECT 'ABCDE_' LIKE 'ABCDE|_' ESCAPE '|';
+------------------------------------+
| 'ABCDE_' LIKE 'ABCDE|_' ESCAPE '|' |
+------------------------------------+
|                                  1 |
+------------------------------------+
1 row in set (0.00 sec)

mysql>








23.21.LIKE
23.21.1.expr LIKE pat [ESCAPE 'escape_char']
23.21.2.To test for literal instances of a wildcard character, precede it by the escape character.
23.21.3.To specify a different escape character, use the ESCAPE clause:
23.21.4.String comparisons are not case sensitive unless one of the operands is a binary string
23.21.5.In MySQL, LIKE is allowed on numeric expressions.