CODE EXAMPLE FOR SQL

find names starting with vowels in sql

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiouAEIOU]';