Weather Observation Station 12

Sort by

recency

|

2435 Discussions

|

  • + 0 comments

    select distinct CITY from STATION where CITY regexp '^[^aeiou].*[^aeiou]$';

  • + 1 comment

    For MySQL Platform

    SELECT DISTINCT city FROM station
    WHERE
        SUBSTR(city, 1, 1) NOT IN ("a", "e", "i", "o", "u")
        AND
        SUBSTR(city, -1) NOT IN ("a", "e", "i", "o", "u");
    
  • + 0 comments
    SELECT DISTINCT CITY FROM STATION 
    WHERE CITY NOT REGEXP  '^[aeiou]|[aeiou]$'
    
  • + 0 comments

    SELECT DISTINCT(city) FROM station WHERE city NOT LIKE '[a,e,i,o,u]%' AND city NOT LIKE '%[a,e,i,o,u]'

  • + 0 comments

    SELECT DISTINCT City FROM Station WHERE City NOT REGEXP '^[aeiou]' AND City NOT REGEXP '[aeiou]$';