find a word in table end with vowel in sql using left code example

Example: query string starts with vowels

select city from station where city REGEXP "^[aeiou].*";