<

MySQL LIKE condition

MySQL, LIKE condition used to perform pattern matching to find the correct result. It is used in SELECT, INSERT, UPDATE and DELETE statement with the combination of WHERE clause.


MySQL LIKE Syntax




expression: LIKE pattern [ ESCAPE 'escape_character' ] 


MySQL LIKE Example



SELECT * FROM employees
WHERE Name LIKE 'c%';















© copyright 2017-2022 Completedone pvt ltd.