Syntax
str RLIKE pat
Purpose
Returns 1 if the string str matches the specified regular expression pat, and 0 otherwise. If either str or pat is NULL, the result is NULL.
This function is a synonym for REGEXP().
Examples
obclient> SELECT 'hello world!' RLIKE '^hello','hello world!' RLIKE '^hello$';
+-------------------------------+--------------------------------+
| 'hello world!' RLIKE '^hello' | 'hello world!' RLIKE '^hello$' |
+-------------------------------+--------------------------------+
| 1 | 0 |
+-------------------------------+--------------------------------+
1 row in set