Weather Observation Station 6

Sort by

recency

|

4963 Discussions

|

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE LEFT(lower(city),1) in ('a', 'e', 'i', 'o', 'u');

  • + 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 SUBSTR(CITY, 1, 1) IN ('A', 'E', 'I', 'O', 'U');

  • + 0 comments

    MYSQL :

    SELECT city FROM STATION WHERE CITY REGEXP '^[a|e|i|o|u]';

    Like is also fine.

  • + 0 comments

    SELECT CITY FROM STATION WHERE UPPER(LEFT(CITY,1)) IN ('A','E','I','O','U');