The SQL LIKE Operator
The LIKE
operator is used in a
clause to search for a specified pattern in a column.
WHERE
There are two wildcards often used in conjunction with the
operator:
LIKE
- The percent sign
%
represents zero, one, or multiple characters - The underscore sign
_
represents one, single character
Example
Select all customers that starts with the letter “a”:
SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';