[SQL] Select City where first letter starts with a vowel

I'm doing some coding challenge.

"Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates."

I solved the challenge with this query:

SELECT DISTINCT city FROM station WHERE (city LIKE 'a%') OR (city LIKE 'e%') OR (city LIKE 'i%') OR (city LIKE 'o%') OR (city LIKE 'u%'); I assume there is a way of doing so without multiple OR statements OR is it?

I have done some searching and it seemes it all required different/extra libraries.

Continue reading...