Just for my own record, dealing with Null type field.
Checking with :
select * from tablename where field1=” -> this one not work
select * from tablename where field1=’Null’ -> same too
is null is the answer
select * from tablename where field1 is null
Save my day, thanks to St4r 🙂