We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 6
Weather Observation Station 6
Sort by
recency
|
4963 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT CITY FROM STATION WHERE LEFT(lower(city),1) in ('a', 'e', 'i', 'o', 'u');
select distinct city from station where (city like 'a%' or city like 'e%' or city like 'i%' or city like 'o%' or city like 'u%');
SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) IN ('A', 'E', 'I', 'O', 'U');
MYSQL :
SELECT city FROM STATION WHERE CITY REGEXP '^[a|e|i|o|u]';
Like is also fine.
SELECT CITY FROM STATION WHERE UPPER(LEFT(CITY,1)) IN ('A','E','I','O','U');