We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 6
Weather Observation Station 6
Sort by
recency
|
4950 Discussions
|
Please Login in order to post a comment
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%';
SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) IN ("A","E","I","O","U") ;
mySQL - regex select distinct city from station where city regexp('^[iaoue]{1}');
select distinct city from station where city regexp '^[aeiou]';
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%';