LIKE Operator

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

SQL LIKE Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

Example

SELECT * FROM Customers
WHERE City LIKE 's%';