First page Back Continue Last page Image

REGEXP_SUBSTR Example Translated

SELECT vendor_city,

REGEXP_SUBSTR(vendor_city, '^SAN|LOS') AS city_match

FROM vendors

WHERE REGEXP_SUBSTR(vendor_city, '^SAN|LOS') IS NOT NULL

List all Cities whose name begins with “Saint” or “The” (In Spanish)