The LIKE command, utilized within a WHERE clause, searches for a specified pattern in a column.
It supports two wildcards:
The provided SQL retrieves all customers whose CustomerName starts with “a”:
| SELECT * FROM Customers WHERE CustomerName LIKE ‘a%’; |
The following SQL retrieves all customers whose CustomerName ends with “a”:
| SELECT * FROM Customers WHERE CustomerName LIKE ‘%a’; |
The following SQL retrieves all customers whose CustomerName contains “or” in any position:
| SELECT * FROM Customers WHERE CustomerName LIKE ‘%or%’; |
The following SQL statement selects all customers with a CustomerName that starts with “a” and are at least 3 characters in length:
| SELECT * FROM Customers WHERE CustomerName LIKE ‘a__%’; |