query string starts with vowels 1

query string starts with vowels

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

Here is what the above code is Doing:
1. Selecting the city column from the station table.
2. Filtering the results to only show cities that start with a vowel.
3. Ordering the results by city in ascending order.

Similar Posts