rlike

Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.

Syntax

expr rlike pat 

Examples

MySQL [(none)]> SELECT 'databend' rlike 'd*';
+-------------------------+
| ('databend' rlike 'd*') |
+-------------------------+
|                       1 |
+-------------------------+