Loading lesson path
Concept visual
Start at both ends
operator is used in a WHERE clause to search for a specified pattern within a column's text data. There are two wildcards often used in conjunction with the LIKE operator:
% - represents zero, one, or multiple characters
_ - represents a single character The following SQL selects all customers that starts with "a":
Select all customers that starts with the letter "a":
SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';column1, column2, ...
table_name
columnN
pattern
;Customers table used in the examples:
Obere Str. 57
12209