I am executing the following query in both MSSQL and MySQL
SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '[aeiou]%'
The only wildcard characters supported by MySQL
% (for any string) and
_ (for any single character). It doesn't support the MSSQL extension
 for character sets. If you need that, use a regular expression, not a wildcard.
SELECT DISTINCT CITY FROM STATION WHERE CITY RLIKE '^[aeiou]'
See List of special characters for SQL LIKE clause for comparisons of
LIKE between different SQL implementations.