You are viewing a single comment's thread. Return to all comments →
MYSQL : 1. SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '[A,E,I,O,U]$';
Also
SELECT DISTINCT(CITY) from STATION WHERE substr(CITY,LENGTH(CITY),1) in ('A', 'E', 'I', 'O', 'U');
SELECT DISTINCT CITY FROM STATION WHERE RIGHT (CITY, 1) IN ('A','E', 'I', 'O', 'U');
Weather Observation Station 7
You are viewing a single comment's thread. Return to all comments →
MYSQL : 1. SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '[A,E,I,O,U]$';
Also
SELECT DISTINCT(CITY) from STATION WHERE substr(CITY,LENGTH(CITY),1) in ('A', 'E', 'I', 'O', 'U');
Also
SELECT DISTINCT CITY FROM STATION WHERE RIGHT (CITY, 1) IN ('A','E', 'I', 'O', 'U');