14 lines
439 B
SQL
14 lines
439 B
SQL
-- Author: Rodney Shaghoulian
|
|
-- Github: github.com/RodneyShag
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
|
|
|
SELECT DISTINCT CITY FROM STATION
|
|
WHERE CITY REGEXP '^[aeiou]';
|
|
|
|
-- Pattern | What the pattern matches
|
|
---------------------------------------
|
|
-- ^ | Beginning of string
|
|
-- [...] | Any character listed between the square brackets
|
|
|
|
-- Useful Reference: https://www.tutorialspoint.com/mysql/mysql-regexps.htm
|