query to select names starting with vowels and ending with w code example

Example: query string starts with vowels

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