Contents

Weather Ovservation Station 9

   Apr 9, 2023     0 min read

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

문제

Weather_Observation_Station_9.jpg

코드

Oracle

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

MySQL

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