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 8
Weather Observation Station 8
Sort by
recency
|
4724 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiouAEIOU].*[aeiouAEIOU]$';
select distinct city from station where city REGEXP '^[aeiou]' and city REGEXP '[aeiou]$';
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' OR 'A%' OR CITY LIKE 'E%'OR CITY LIKE 'I%' OR CITY LIKE 'O%'OR CITY LIKE 'U%'
SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') AND UPPER(RIGHT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U');
SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') AND UPPER(RIGHT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U');