Skip to main content

regexp

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

Syntax​

expr REGEXP pat

Examples​

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