Excluding Data

In my database table, I have a field called category. There are four categories available to list by: News | Review | ABC | 123,

How can I write a mysql_query() to list all the data for every category except NEWS?

I checked the mysql manual (and I'm still checking) for an exclude sort of function but haven't found one yet.

Could this be your solution?
select * from <table> where category <> 'NEWS'

I think you made a mistake. If the query is:

SELECT * FROM <table> WHERE category = 'NEWS'

Then it would only list the stuff with NEWS.

How can I write a mysql_query() to list all the data for every category except NEWS?

my reply was (and still is)
select * from <table> where category <> 'NEWS'

Oh sorry, I missed that <>. What does that do?

<> different from same as !=

You could also write the following

select * from <table> where not (category='NEWS')

If you wanna do it for more than one, use not in, it's more intuitive than not or/ands.

select * from table where category not in ("News","123");

Drop the not and you have the opposite.

Note that I think you can now use sebselects in in() constructs in MySQL now, so you could do something like:

select * from table where category not in (select category from table group by category having count(category)>2)

kinda thing.