Weather Observation Station 11

Sort by

recency

|

4060 Discussions

|

  • + 1 comment

    SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '^[aeiouAEIOU]' OR CITY NOT REGEXP '[aeiouAEIOU]$';

  • + 0 comments

    SELECT DISTINCT (city) FROM station WHERE city not like '[aieou]%[aieou]';

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE RIGHT(city,1) NOT IN ('a','e','i','o','u') OR LEFT(city,1) NOT IN ('A','E','I','O','U');

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE LOWER(SUBSTR(CITY, 1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u') OR LOWER(SUBSTR(CITY, -1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u');

  • + 0 comments

    using regex

    select distinct city from station where city regexp '^[^aeiou]|[^aeiou]$'