/SQL/What is the difference between the LIKE and REGEXP operators in mysql?

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

Similar codes

0 vote152 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote183 views1 answer
Add week ending date sql server
SQL
0 vote141 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote136 views1 answer
Rename view mysql
SQL
5 votes156 views1 answer
Oracle columns in all_tables
SQL
0 vote189 views1 answer
Sql int vs integer
SQL
0 vote140 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
8 votes148 views1 answer
Show mysql user table
SQL
0 vote138 views1 answer
How to close external sql connection in laravel
SQL
1 vote121 views1 answer
Oracle rolling back
SQL