What is the difference between LIKE and REGEXP operators in MySQL?

  • LIKE is denoted using the % sign. For example:SELECT * FROM user WHERE user name LIKE “%NAME”.• On the other hand the use of REGEXP is as follows:SELECT * FROM user WHERE username REGEXP “^NAME”;

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What does myisamchk do

How to get the current date in MySQL?

What does " i_am_a_dummy flag" do in MySQL?

Can you use MySQL with LINUX operating system?

How do you login to MySql using Unix shell?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What is the difference between LIKE and REGEXP operators in MySQL?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges