:clap: Thanks !!!
Wm Mussatto wrote:
> On Tue, June 3, 2008 16:05, SenTnel wrote:
>> Hi all!
>> My database has a lot of empty fields in the "street" column, meaning
>> lot of streets has no name registered, they're just plain blank.
>> What I would like to do is to INSERT something like "N/A" (Not Available)
>> every field that is empty in the "street" column, but don't know exactly
>> SQL statemet to tell:
>> "In mytable, street column, insert 'N/A' in every empty space"
> update mytable set street='N/A' where (rtrim(street)='' or street is NULL)
> I always do a
> select * from mytable where (rtrim(street)='' or street is NULL) limit 10
> as a test first.
> William R. Mussatto
> Systems Engineer
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
View this message in context:
Sent from the MySQL - General mailing list archive at Nabble.com.