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%';