Weather Observation Station 7 / HackerRank, SQL, MySQL

문제

Query the list of CITY names ending with vowels (a, e, i, o, 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$'

 

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 '[aeiou]$'

 

 

문제 바로가기(MySQL)