'How to get vowels in Like operator of SQL?

I was solving a problem on SQL from Hackerrank. I have to make a query such that it gives me all city names starting with a, e, i, o or u. I'm using Like operator but still wrong answer.

Here's the problem Link

Here's my solution-

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

Can anybody explain?

mysqlsqlstringwhere-clausesql-like


Solution 1:[1]

select distinct city from station where Left(city,1)='A' or Left(city,1)='E' or Left(city,1)='I' or Left(city,1)='O' or Left(city,1)='U';

This worked fine with me (MS SQL)

Solution 2:[2]

SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U');

This return the City names starting with vowel.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 umurislamoglu
Solution 2 Chandan

Related Questions