Description

The REGEXP( ) function returns 1 if the expr matches with pat. It returns 0 if it doesn’t matches. Returns NULL if either expr or pat is NULL.

This function has the form:

SELECT REGEXP(expr, pat)

Parameter	Description
expr	Expression
pat	Pattern

Return Value

Returns 1 if the expr matches with pat. It returns 0 if it doesn’t matches. Returns NULL if either expr or pat is NULL.

Examples

The following example shows the basic use of this function:

mysql> SELECT 'Monty!' REGEXP '.*';
-> 1
mysql> SELECT 'new*\n*line' REGEXP 'new\\*.\\*line';
-> 1
mysql> SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A';
-> 1 0
mysql> SELECT 'a' REGEXP '^[a-d]';
-> 1