Weather Observation Station 7

Sort by

recency

|

3207 Discussions

|

  • + 0 comments

    select distinct city from station where RIGHT(CITY, 1) IN ('A','E','I','O','U'); Works in sql

  • + 0 comments

    For MySQL

    SELECT DISTINCT city FROM station
    WHERE SUBSTR(city, -1) IN ("a", "e", "i", "o", "u");
    
  • + 0 comments
    select distinct city from station where
    
    city REGEXP '[aeiou]$'
    
  • + 0 comments

    select distinct city from station where city LIKE '%a' or city LIKE '%e' or city LIKE '%i' or city LIKE '%o' or city LIKE '%u'

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