Regular Expression

MySQL Regular Expression Operators
The following operators are used in MySQL to perform regular expression operations.
These are used in a WHERE clause similar to the well-known and often used LIKE operator.
• REGEXP: The pattern matching operator for using regular expressions.
• NOT REGEXP: The negation of the REGEXP operator.
• RLIKE: A synonym for the REGEXP operator.