Weather Observation Station 10

Sort by

recency

|

2226 Discussions

|

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '[AEIOUaeiou]$'

  • + 0 comments

    For MySQL Platform

    SELECT DISTINCT city FROM station
    WHERE RIGHT(city, 1) NOT IN ("a", "e", "i", "o", "u");
    
  • + 0 comments

    select DISTINCT(city) from station where right(city,1) NOT in ('a','u','o','i','e')

  • + 0 comments
    SELECT DISTINCT CITY FROM STATION 
    WHERE CITY NOT REGEXP '[a,e,i,o,u]$'
    
  • + 1 comment

    SELECT DISTINCT CITY FROM STATION WHERE substr(CITY,-1,1) NOT in ('A','E','I','O','U','a','e','i','o','u');