Define REGEXP ?

REGEXP is a pattern match in which  matches pattern anywhere in the search value.

 

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”;