% -- Equates to zero or more characters. -- Example: Find all customers with surnames ending in ‘ory’. SELECT * FROM customers WHERE surname LIKE '%ory'; _ -- Equates to any single character. -- Example: Find all customers living in cities beginning with any 3 characters, followed by ‘vale’. SELECT * FROM customers WHERE city LIKE '_ _ _vale'; [charlist] -- Equates to any single character in the list. -- Example: Find all customers with first names beginning with J, K or T. SELECT * FROM customers WHERE first_name LIKE '[jkt]%';