You are viewing a single comment's thread. Return to all comments →
select distinct city from station where left(city,1) not in ('a','e','i','o','u');
select distinct city from station where city not regexp '^[aeiou]';
Weather Observation Station 9
You are viewing a single comment's thread. Return to all comments →
select distinct city from station where left(city,1) not in ('a','e','i','o','u');
select distinct city from station where city not regexp '^[aeiou]';