Re: MySQL and NULL entires

[Karl Pielorz]

Mike Machado wrote:

> update account set billgroup = "1" where billgroup = "NULL";

Any test with NULL in, is by definition FALSE, therefore the correct way of
doing the above is:

update account set billgroup = 1 where billgroup IS NULL;

Confusing, but you'll get the hang of it... :-)  (IS NULL is a MySQL test for
NULL, that returns TRUE if the item being tested 'is null')

Regards,

Karl