mysql regexp vs like code example
Example: What is the difference between the LIKE and REGEXP operators in mysql?
LIKE and REGEXP operators are used to express with ^ and %.
SELECT * FROM employee WHERE emp_name REGEXP "^b";
SELECT * FROM employee WHERE emp_name LIKE "%b";