regexp
Checks whether a given expression matches the regular expression specified by pattern
. If yes, 1 is returned. Otherwise, 0 is returned. NULL is returned if any of the input parameter is NULL.
regexp() supports more complex matching conditions than like().
Syntaxβ
BOOLEAN regexp(VARCHAR expr, VARCHAR pattern);
Parametersβ
-
expr
: the string expression. The supported data type is VARCHAR. -
pattern
: the pattern to match. The supported data type is VARCHAR.
Return valueβ
Returns a BOOLEAN value.
Examplesβ
mysql> select regexp("abc123","abc*");
+--------------------------+
| regexp('abc123', 'abc*') |
+--------------------------+
| 1 |
+--------------------------+
1 row in set (0.06 sec)
select regexp("abc123","xyz*");
+--------------------------+
| regexp('abc123', 'xyz*') |
+--------------------------+
| 0 |
+--------------------------+
Keywordsβ
regexp, regular