SQL select question

[Anon]

How do I do a 'NOT' in a select?

"Select * from blah_table where blah_field NOT = '$stuff'"

THanks

George Loch

[mithril]

George,

SELECT * FROM blah_table WHERE blah_field != '$stuff'

or:

SELECT * FROM blah_table WHERE blah_field <> '$stuff'

HTH.

Cheers,

Geoff A. Virgo