starts and end with vowel sql

Solutions on MaxInterview for starts and end with vowel sql by the best coders in the world

showing results for - "starts and end with vowel sql"
Ned
14 Jan 2021
1SELECT DISTINCT CITY 
2FROM STATION  
3WHERE CITY regexp '^[AEIOU]%' and CITY regexp '[aeiou]$';
Caterina
05 Nov 2018
1SELECT DISTINCT CITY 
2FROM STATION  
3WHERE CITY LIKE '[AEIOU]%' and CITY LIKE '%[aeiou]';