REGEXP is a pattern match in which matches pattern anywhere in the search value.
Tag: REGEXP
What is the difference between the LIKE and REGEXP operators?
LIKE and REGEXP operators are used to express with ^ and %.
Example:
SELECT * FROM table WHERE column REGEXP “^x”;
SELECT * FROM table WHERE column LIKE “%x”;