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
|
4435 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 LIKE '[aeiou]%' AND CITY LIKE '%[aeiou]';
why it is not working?
SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) IN ('A','E','I','O','U') AND RIGHT(CITY,1) IN ('A','E','I','O','U');
SELECT DISTINCT city FROM station WHERE city RLIKE '^[aeiou].*[aeiou]$';
select distinct city from station where left(city,1) in('a','e','i','o','u') and right(city,1) in ('a','e','i','o','u') this will work