Prepare > SQL > Basic Select > Weather Observation Station 9

Weather Observation Station 9 | HackerRank

 

문제

---

Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

 

 

 

 

코드

---

SELECT DISTINCT(CITY) FROM STATION
WHERE CITY NOT LIKE "A%"
    AND CITY NOT LIKE "E%"
    AND CITY NOT LIKE "I%"
    AND CITY NOT LIKE "O%"
    AND CITY NOT LIKE "U%";

SELECT DISTINCT(CITY) FROM STATION
WHERE LEFT(CITY,1) REGEXP "[^AEIOU]";

SELECT DISTINCT(CITY) FROM STATION
WHERE CITY REGEXP "^[^AEIOU]";

 

 

 

 

노트

---

REGEXP "[^부정]"

• 정규표현식 REGEXP "[^부정]"
• "부" 와 "정"을 포함하지 않는 문자열을 찾음
• '부자' 와 '정말' 모두 제외됨