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 9
Weather Observation Station 9
Sort by
recency
|
3084 Discussions
|
Please Login in order to post a comment
select distinct(city) from station where city regexp '^[^UEOAIueoai]';
These are the most frequent issues that arise when we integrate the Fiverr Gig Rank Checker SQL to investigate the situation. For further details, go to the website. Many specialists are trying to tackle the issue, but none of them have been able to do it yet.
SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT(CITY , 1)) NOT IN ('A','E','I','O','U')
My solution for MySQL:
SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '^[AEIOUaeiou]';
Try this one -- select distinct city from station where not city regexp '^[aeiou]'