SQLzoo.net

How do I use LIKE in a sql SELECT statement

Oracle
The LIKE command allows "Wild cards". A % may be used to match and string, _ will match any single character. The example shows countries begining with Z. The country Zambia matches because ambia matches with the %.	SELECT name FROM bbc WHERE name LIKE 'Z%'
Specific to Oracle
none