try updating the table like this... update TABLE set COLUMN = replace(COLUMN, >,);
-----Original Message----- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 3:30 PM To: MySql Subject: remove trailing character I managed to mess up and email storage addresses are in the format of [EMAIL PROTECTED]> How I can strip off the ">", it does not exist on all, only some. thanks -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Fax: 313.557.5052 <[EMAIL PROTECTED]> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
