Regex

• Starts with vowel

  SELECT DISTINCT city FROM station WHERE city REGEXP "^[aeiou].*";
  

• does not start with vowel:

  WHERE city NOT RLIKE "^[aeiou].*"
  

• ends in vowel

  [aeiou]$
  

• starts and ends with vowel

  ^[aeiou].*[aeiou]$