MYSQL, is there a don't include?
Posted: Tue Jan 18, 2011 9:27 am
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 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.