finding empty mysql fields?

[viveleroi0]

I have a mysql database that has products listings, I sometimes there is an error when certain fields are left blank. The ones that somehow got a space, or another character where there shouldn;t be, is easy to find.

But how can I search the database for fields that have no data? I tried:

... WHERE field="" ...

but that just returns the entire database.

Any ideas?

[laserlight]

What if you try using NULL?

[viveleroi0]

Nope... I tried that and it doesn't work.

Thanks for the suggestion though.

[laserlight]

what about
WHERE field IS NULL
?