From: Martijn Tonies
Date: September 5 2007 11:02am
Subject: Re: Editing fields in bulk
List-Archive: http://lists.mysql.com/mysql/208918
Message-Id: <00fb01c7efac$3c83c330$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> I have a column where I need to replace all instances of the text "US- 
> Complete" (contained within a long sentence) with "US Complete".  
> There are probably 50 or 100 of them. I'm really scared to do it  
> since I can't risk screwing up that column - what's the correct syntax?

When you screw up, that's when you do a "rollback". Welcome to
transactions.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com