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.
Weather Observation Station 8
Weather Observation Station 8
Sort by
recency
|
4751 Discussions
|
Please Login in order to post a comment
select distinct city from station where city regexp '^[aeiou]' and city regexp '[aeiou]$'
why isnt this working?
SELECT DISTINCT(CITY)
FROM STATION
WHERE SUBSTR(CITY, 1,1) IN ('a', 'e', 'i', 'o', 'u')
AND SUBSTR(CITY, -1, 1) IN ('a', 'e', 'i', 'o', 'u');
ORSELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '^[aeiou]' AND CITY REGEXP '[aeiou]$';
SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT, 1)) IN ('A', 'E', 'I', 'O', 'U') AND UPPER(RIGHT, 1)) IN ('A', 'E', 'I', 'O', 'U');
-- MS SQL server
SELECT Distinct CITY FROM STATION WHERE CITY LIKE '[aeiou]%[aeiou]'