Contents

Weather Ovservation Station 7

   Apr 9, 2023     0 min read

Weather Ovservation Station 7 정규표현식 튜토리얼 정규표현식 테스트 해볼 수 있는 사이트

문제

Weather_Observation_Station_7.jpg

코드

Oracle

SELECT DISTINCT CITY
FROM STATION
WHERE REGEXP_LIKE (CITY, '[aeiou]$', 'i')
;

MySQL

SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '.*[aeiou]$'