How to use LIKE conditions in MySQL?

MySQL LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards used in conjunction with the LIKE operator:

• % - The percent sign represents zero, one, or multiple characters
• _ - The underscore represents a single character

SELECT column1, column2,column3 FROM table_name WHERE columnN LIKE pattern;