Answers for "names starting and end with vowels in sql"

starts and end with vowel sql

SELECT DISTINCT CITY 
FROM STATION  
WHERE CITY LIKE '[AEIOU]%' and CITY LIKE '%[aeiou]';

Posted by: Guest on September-22-2021

starts and end with vowel sql

SELECT DISTINCT CITY 
FROM STATION  
WHERE CITY regexp '^[AEIOU]%' and CITY regexp '[aeiou]$';

Posted by: Guest on September-22-2021

selecting names ending with vowels in sql

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[aeiouAEIOU]$';

Posted by: Guest on February-16-2022

Code answers related to "names starting and end with vowels in sql"