SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A'; : REGEXP « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. REGEXP
mysql>
mysql> SELECT 'a' REGEXP '^[a-d]';
+---------------------+
| 'a' REGEXP '^[a-d]' |
+---------------------+
|                   1 |
+---------------------+
1 row in set (0.00 sec)

mysql>








23.31.REGEXP
23.31.1.expr REGEXP pat, expr RLIKE pat: Performs a pattern match of expr against pat
23.31.2.SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A';