regexp
Description
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