regexp_like similar function in MySQL?

Viewed 6775

I was trying to solve a problem in SQL and I came across the problem:

Query the list of CITY names from STATION table that do not start with vowels. Your result cannot contain duplicates.

enter image description here

I used regexp_like() function using Oracle but how I can query the results using MySQL?

In Oracle I did regexp_like(city, '^[^aeiou]', 'i')

2 Answers
Related