SQL LIKE Operator

01/27/2014
| No Comments

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

The SQL LIKE Operator

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;

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%'; 

or

SELECT * FROM Customers
WHERE Country LIKE '%land%';
SQL