4. What is the difference between the LIKE and REGEXP operators?

What is the difference between the LIKE and REGEXP operators?

Answer

LIKE and REGEXP operators are used to express with ^ and %.

 
1
2
SELECT *FROM employee WHERE emp_name REGEXP"^b";
SELECT *FROM employee WHERE emp_name LIKE"%b";

All Mysql Questions
Ask your interview questions on mysql

Write Your comment or Questions if you want the answers on mysql from mysql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---