SQL Query

Just a quick on

if I want to select all data EXCEPT forum_id='12' AND forumid='14' is there a simple way to do this?

Basically I have a recent forum posts table on my home pages and I want it to ignore the new forums & complaints forum

SELECT * FROM data WHERE forum_id <> '12' AND forum_id <>'14'

thanks

Ludichrist wrote:

SELECT * FROM data WHERE forum_id <> '12' AND forum_id <>'14'

or, if you've ever got more than a couple values you want to exclude, you can use something like this:

SELECT * FROM data WHERE forum_id NOT IN ('12', '14', '15');

good luck