MySQL != (does NOT equal) ?

[cmason22]

ok, sorry for what is probably a very lame question, but how can i do a select from where a certain field does NOT equal something.

i.e.

SELECT * from table where catagory DOES NOT = 'ignored category';

thanks!

charlie

[Pig]

WHERE id!='whatever'

[tomhath]

SELECT * from table where NOT category = 'ignored category';

SELECT * from table where category != 'ignored category';

SELECT * from table where category <> 'ignored category';

SELECT * from table where category NOT LIKE 'ignored category';

Probably others I can't think of right now.