WHERE column IS NOT '$value'?

Question

I'm trying to select everything from the database except one thing.

Using the syntax in the title doesn't work, is their another way?

Answer 1

Try this:

WHERE column != '$value'

IS NOT is used with NULL

eg:

WHERE column IS NOT NULL

Answer 2

WHERE column <> '$value'