SQL

find names starting with vowels in sql

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

sql name ends with vowels

select distinct city
from station
where substring(city,len(city),1) in ('a','e','u','o','i')
order by city;

vowels in sql

SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY,1,1) IN ('A','E','I','O','U') AND SUBSTR(CITY,-1,1) in ('A','E','I','O','U');

selecting names ending with vowels in sql

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