Re: MySQL and NULL entires

[Chris]

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";