Loading lesson path
Concept visual
Start at both ends
A wildcard character is used to substitute one or more characters in a string.
operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
Return all customers that starts with the letter 'a':
SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';%
_
[] Represents any single character within the brackets * ^ Represents any character not in the brackets *
Represents any single character within the specified range *
{}Represents any escaped character * Not supported in PostgreSQL and MySQL databases. Supported only in Oracle databases.
Customers table used in the examples:
Obere Str. 57
12209
Avda. de la Constitución 2222 México D.F. 05021
Antonio Moreno TaquerÃa