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.