How do I write a sql query to select names that can contain any vowel?

Question

I am trying to query a database with about 2000 records. I want to select records where names can contain any vowel.

I tried using the following query, but it gives me those entries that contain all the characters specified in that order.

select * from myTable where name like '%a%e%i%';

How to change the above query to select those records with names that can contain at least one of the vowels.

+3

user4658312 June 29. 15 at 11:52

5 answers

Try this for SQL Server:

SELECT * FROM myTable WHERE name LIKE '%[AEIOU]%';

+2

dario June 29. 15 at 11:55

In SQL Server, you must:

where name like '%[aeiou]%';

In MySQL, you would do something similar with a regex.

+1

Gordon linoff June 29. 15 at 11:55

Use OR

as follows.

This will work for both SQL Server and MySql.

select * from myTable where name like '%a%' OR name like '%e%' OR name like '%i%';

+1

ughai June 29. 15 at 11:55

Use LIKE

and OR

.

Query

select * from myTable
where name like '%a%'
or name like '%e%'
or name like '%i%'
or name like '%o%'
or name like '%u%'

0

Wanderer June 29. 15 at 11:55

Negom · Accepted Answer · 2015-06-29T12:35:59+0000

Hope this helps you ...

 SELECT * FROM myTable WHERE name REGEXP 'a|e';
 or.....
 SELECT * FROM myTable WHERE name REGEXP 'a|e|i';