MySQL query fetching different data than expected

Question

I am using MySQL, I have a table mtn_extract_list_email where there are columns called company,office,email,country and rating

I dont want emails that have domains aol , gmail, google

the query I am using is

select email from mtn_extract_list_email where (company like '%XYZ%' or office like '%XYZ%')
and (email not like '%@aol%' or email not like '%@gmail%' or email not like '%@google%')
and (Country = 'USA' and rating like 'A%')  
and email is not null;

this query fetches data but i noticed that it also fetched one email with @gmail as domain. I tried adjusting "AND" and "or" logic but still no luck. please guide what is wrong with my query.

Please edit your question title to something that describes the actual problem you're having. Query not working How'd I like will have absolutely no meaning if it turns up in a search result for a future user of this site. Your title should actually be descriptive; it's clear your query isn't working as you'd like, or you wouldn't be posting a question here. — Ken White
– Ken White, Commented Feb 5, 2015 at 23:18
You don't want domains in aol, AND you don't want gmail, AND you don't wan't google. The problem is that your query uses OR. — LSerni
– LSerni, Commented Feb 5, 2015 at 23:19
(email not like '%@aol%' AND email not like '%@gmail%' AND email not like '%@google%') — Carlos González
– Carlos González, Commented Feb 5, 2015 at 23:20

BK435 · Accepted Answer · 2015-02-05 23:21:24Z

1

You are using or instead of and.

select email from mtn_extract_list_email 
        where (company like '%XYZ%' or office like '%XYZ%')
        (email not like '%@aol%' AND email not like '%@gmail%' AND email not like '%@google%')
        and (Country = 'USA' and rating like 'A%')  
        and email is not null;

answered Feb 5, 2015 at 23:21

BK435

3,1863 gold badges22 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query fetching different data than expected

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related