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

• mysql when null