The LIKE operator is used to search for a specified pattern in a column.
SQL LIKE Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;
FROM table_name
WHERE column_name LIKE pattern;
SQL LIKE Operator Examples
The following SQL statement selects all customers with a City starting with the letter "s":
Example
SELECT * FROM Customers
WHERE City LIKE 's%';
WHERE City LIKE 's%';