In MySQL, LIKE is allowed on numeric expressions. : LIKE « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. LIKE
mysql>
mysql> SELECT 10 LIKE '1%';
+--------------+
| 10 LIKE '1%' |
+--------------+
|            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.