Answers for "take names that start with vowel and end with non vowel 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

Code answers related to "take names that start with vowel and end with non vowel in sql"