Learning On Demand

Learning anything from anywhere

MySQL and Null

by alamster in May 16th, 2008   
Database     Tags: ,

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 :-)

No Comment

Random Post

Leave Your Comments Below

Please Note: All comments will be hand modified by our authors so any unsuitable comments will be removed and you comments will be appreared after approved

« Do not fix something ain’t broken
Oracle XE for network access »