Like
How do I use LIKE in a sql SELECT statement.
schema:gisq
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*'
SELECT name FROM bbc
WHERE name LIKE 'Z%'