MYSQL, is there a don't include?

[dhope]

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.

 

I hope this makes sense

[bh]

Hi,

 

SELECT * FROM areas WHERE county != 'xxxx' GROUP BY county ORDER BY county_category;

 

 

or http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_not-in

[dhope]

Worked a treat, thank you bh.