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”;
MySQL Interview Questions and Answers
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”;