Is the WHERE table NOT "$ value"?

Question

I am trying to select everything from the database except one.

Using the syntax in the header doesn't work, is this their other way?

Answer 1

WHERE column <> '$value'

Answer 2

Try the following:

WHERE column != '$value'

IS NOT used with null

eg:

WHERE column IS NOT NULL