Weather Observation Station 11

Sort by

recency

|

4041 Discussions

|

  • + 0 comments

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

  • + 0 comments

    select distinct(city) as dist_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 city not like 'a%'and city not like 'e%' and city not like 'i%' and city not like'o%' and city not like 'u%' or city not like '%a'and city not like '%e' and city not like '%i' and city not like'%o' and city not like '%u' ;

  • + 0 comments

    select distinct city from station where city not regexp '^[aeiou].*[aeiou]$';

  • + 0 comments

    select distinct city from station where LOWER(LEFT(CITY,1)) NOT IN ('a','e','i','o','u') or LOWER(RIGHT(CITY,1)) NOT IN ('a','e','i','o','u');