MySQL solution

Useful REGEXP Reference

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

^ matches Beginning of string
[...] matches Any character listed between the square brackets

From my HackerRank solutions.

Let me know if you have any questions.