From: Karl Pielorz
Date: March 12 1999 9:20am
Subject: Re: MySQL and NULL entires
List-Archive: http://lists.mysql.com/mysql/107
Message-Id: <36E8DC59.B771DB0F@tdx.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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