Simple mysql syntax question

[reub77]

I need to pull all the records from the database that belong to the same group. Say for instance the same country.

I only want to call the records that have at least one value filled in among two different fields. Lets say Home and Work Email addresses as the fields. They need to have at least one email between them both otherwise I want to forget about them and move to the next.

What is the best way to perform this mysql call?

I've been doing it this way but I'm running into problems:

SELECT email,h_email FROM demographics WHERE country='United States' AND email LIKE '%@%' OR h_email LIKE '%@%'

The problem I'm getting is that I don't get only countries from US but others from the database as well. And I'm not completely sure if I'm getting all those with emails.

I'm all ears if someone has a better call for this query.

Thanks

[LordShryku]

Give this a shot. Can't say it'll work better. The time difference is probably milliseconds.

SELECT email, 
       h_email 
  FROM demographics 
 WHERE country = 'United States' 
   AND (email IS NOT NULL 
        OR h_email IS NOT NULL)

[reub77]

I don't know why because your query looked great. But I'm not getting the results I'm supposed to get at all. I was supposed to get a list of results from United States with at least one e-mail.

What I got was only the results from Canada, they did have e-mails however. Is there a problem maybe with the order of the calls? When I take out the last part that defines only ones with e-mails I get all the United States. So that would tell me that the query for United States is right and that there are records to pull.

Any ideas?

[reub77]

Neither way was right. The way that worked was:

SELECT email,h_email
FROM demographics 
WHERE country = 'United States' 
AND (email LIKE '%@%' OR h_email LIKE '%@%')

You got me on the right track though. Thanks.