sql query : show name with all vowels

Try using and name LIKE '%a%' for your vowels, this will search the entire string and not just the last letter.

For example:

SELECT name
FROM world
WHERE name LIKE '%u%' 
  and name LIKE '%a%' 
  and name LIKE '%o%' 
  and name LIKE '%i%'
  and name LIKE '%e%'
  and name NOT LIKE '% %'

SELECT name FROM world WHERE name LIKE '%a%' AND
                             name LIKE '%e%' AND
                             name LIKE '%i%' AND
                             name LIKE '%o%' AND
                             name LIKE '%u%'

Tags:

Mysql

Sql

Related