SQL query to check if a name begins and ends with a vowel

by

You could use a regular expression:

SELECT DISTINCT city
FROM   station
WHERE  city RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$'

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. SQL query return data from multiple tables
  4. quick selection of a random row from a large table in mysql
  5. MySQL SELECT only not null values
  6. Ordering by specific field value first
  7. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  8. Checking multiple columns for one value
  9. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  10. MySQL INSERT INTO … VALUES and SELECT
  11. MySQL error 1241: Operand should contain 1 column(s)
  12. How to select one row randomly taking into account a weight?
  13. quick selection of a random row from a large table in mysql
  14. Compare only day and month with date field in mysql
  15. Syntax error when using except in a query
  16. SELECT query return 1 row from each group
  17. MySQL INNER JOIN select only one row from second table
  18. MySQL Select Query – Get only first 10 characters of a value
  19. How to SELECT by MAX(date)?
  20. Which DB technology is sued to solve the following search issue? [closed]
  21. MySQL – Operand should contain 1 column(s)
  22. mysql pivot/crosstab query
  23. MySQL: Split comma separated list into multiple rows
  24. Remove Primary Key in MySQL
  25. Get most recent row for given ID
  26. Is merge statement available in MySQL
  27. Mysql covering vs composite vs column index
  28. Insert/ Update random date in MySQL
  29. Replace null with 0 in MySQL
  30. SQL (MySQL) vs NoSQL (CouchDB) [closed]

Leave a Comment