LIKE和REGEXP操作有什么区别？

LIKE和REGEXP运算符用于表示^和％。

SELECT * FROM employee WHERE emp_name LIKE "%b";

SELECT * FROM employee WHERE emp_name REGEXP "^b";