Weather Observation Station 6 / HackerRank, SQL, MySQL

문제

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. Input FormatThe STATION table is described as follows:

 

 

제출답안(MySQL)

SELECT DISTINCT(city) FROM station
WHERE city REGEXP '^a|^e|^i|^o|^u'

 

 

 

풀이(MySQL)

MySQL 정규식 적용

참고자료 - https://www.geeksforgeeks.org/mysql-regular-expressions-regexp/

 

개선답안(MySQL)

SELECT DISTINCT(city) FROM station
WHERE city REGEXP '^[aeuio]'

 

 

문제 바로가기(MySQL)