We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 9
  5. Discussions

Weather Observation Station 9

  • zexianxu
     + 2 comments

    Hello,

    May I ask if there is any difference if we add .* into the expression:

    SELECT DISTINCT CITY FROM STATION
WHERE CITY REGEXP '^[^aeiou.*]';

SELECT DISTINCT CITY FROM STATION
WHERE CITY REGEXP '^[^aeiou].*';

    Edit: Based on the comments below, the 1st expression above is not correct because it means the string doesn't start with a,e,i,o,u and also doesn't start with . or *.

    But how about the 2nd expression? I'm wondering whether it is correct or not.

    Thanks!