CODE EXAMPLE FOR SQL

starts and end with vowel sql

SELECT DISTINCT CITY 
FROM STATION  
WHERE CITY regexp '^[AEIOU]%' and CITY regexp '[aeiou]$';