From: Chris
Date: March 12 1999 2:22pm
Subject: Re: MySQL and NULL entires
List-Archive: http://lists.mysql.com/mysql/92
Message-Id: <Pine.LNX.3.96.990312092005.926E-100000@hiro.studentadvantage.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


It won't work to use 'NULL' as a parameter in an '=' comparison...use
ISNULL instead:

UPDATE ACCOUNT SET billgroup = '1' WHERE ISNULL(billgroup);

--Chris

On Thu, 11 Mar 1999, Mike Machado wrote:

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