regexp

[SQL] REGEXP

https://indistract.tistory.com/13 [SQL] 조건에 맞는 문자열 검색 https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com Query the list of CITY names from STATION which hav indistract.tistory.com 위 게시글에서는 조건에 맞는 문자열을 검색하는 방법을 다뤘다. LEFT(), RIGHT() 함수를 이용할수도 있지만..

[SQL] 조건에 맞는 문자열 검색

https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. 먼저, 문제에서는 모음으로 시작하고, 모음으로 끝..