Answers for "starting with vowels sql"

query string starts with vowels

select city from station where city REGEXP "^[aeiou].*";

Posted by: Guest on March-16-2020

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

vowels in sql

SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY,1,1) IN ('A','E','I','O','U') AND SUBSTR(CITY,-1,1) in ('A','E','I','O','U');

Posted by: Guest on November-01-2021

Code answers related to "starting with vowels sql"