Weather Observation Station 6

Sort by

recency

|

4950 Discussions

|

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

  • + 0 comments

    mySQL - regex select distinct city from station where city regexp('^[iaoue]{1}');

  • + 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%';