expr REGEXP pat, expr RLIKE pat: Performs a pattern match of expr against pat : REGEXP « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. REGEXP

Returns 1 if expr matches pat; otherwise it returns 0.

If either expr or pat is NULL, the result is NULL.

REGEXP is not case sensitive, except when used with binary strings.

RLIKE is a synonym for REGEXP.

mysql>
mysql>
mysql> SELECT 'ABCDEF' REGEXP 'A%C%%';
+-------------------------+
| 'ABCDEF' REGEXP 'A%C%%' |
+-------------------------+
|                       0 |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT 'ABCDE' REGEXP '.*';
+---------------------+
| 'ABCDE' REGEXP '.*' |
+---------------------+
|                   1 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT 'new*\n*line' REGEXP 'new\\*.\\*line';
+---------------------------------------+
| 'new*\n*line' REGEXP 'new\\*.\\*line' |
+---------------------------------------+
|                                     1 |
+---------------------------------------+
1 row in set (0.00 sec)

mysql>