From: Ed Carp
Date: March 12 1999 9:32am
Subject: Re: MySQL and NULL entires
List-Archive: http://lists.mysql.com/mysql/108
Message-Id: <199903120932.DAA14431@wats-ts4-12.ppp.iadfw.net>
Content-Type: text

Attachment: <a href="/mysql/108/1">[text]</a><br />
> 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";
> 

update account set billgroup=1 where billgroup is null;
--
Ed Carp, N7EKG  	erc@stripped		940/367-2744 cell phone
Owner: WeatherAlert/Digital Weatherman - NWS alerts via email/pager/Internet
       DSOUTH-L backup, Terrorism, Shamanism, Hurricane mailing lists
		http://www.pobox.com/~erc

"i have my plans and brave ambitions, knowing no bounds, no inhibitions..."
Basia Trzetrzelewska, "Third Time Lucky"