Page 1 of 1

MYSQL, is there a don't include?

Posted: Tue Jan 18, 2011 9:27 am
by portem1
Hi,

I am trying to create a table from information in my database but I dont want to include certain records. So far I have got:

SELECT * FROM areas GROUP BY county ORDER BY county_category

Is there way to say select all from areas but if county is equal to "xxxx", dont include this recored?

I'm sure there is an easy way of doing this but I can't seem to work it out, please can someone point me in the right direction.

Re: MYSQL, is there a don't include?

Posted: Tue Jan 18, 2011 9:38 am
by Darhazer
SELECT * FROM areas WHERE country NOT IN('xxxx') GROUP BY county ORDER BY county_category