% -- 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]%';
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter