Declaration
str RLIKE pat
Description
Determines whether a string matches a regular expression. If the string str matches the specified regular expression, 1 is returned; otherwise, 0 is returned. If either str or pat is NULL, the return value 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