we use "like" in query as SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern and used to search for a specified pattern in a column.
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
and used to search for a specified pattern in a column.