[MySQL] Weather Observation Station 9

▶  SQL  >  Basic Select  > Weather Observation Station 9 

 Problem 

Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

The STATION table is described as follows:

→ 모음으로 시작하지 않는 CITY names, 중복X

 My Answer 

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

* REGEXP에 대한 내용은 Weather Observation Station 6 포스팅 참고