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
|
3919 Discussions
|
Please Login in order to post a comment
* Oracle *
select distinct(city) from station where substr(city,1,1) in ('A', 'E', 'I', 'O', 'U') and substr(city,-1,1) in ('a', 'e', 'i', 'o', 'u');
USE LEFT and RIGHT function
select distinct(city) from STATION where LOWER(RIGHT(city, 1)) in ('a','e','i','o','u') AND LOWER(LEFT(city, 1)) in ('a','e','i','o','u');
SELECT distinct city from station WHERE city REGEXP '^[a|e|i|o|u| ]+[a-z| ]+(a|e|i|o|u| )+$';