How about UPDATE table set email = TRIM(TRAILING '>' FROM email) http://dev.mysql.com/doc/mysql/en/string-functions.html
Greg Fortune On Thursday 10 March 2005 03:29 pm, Scott Haneda wrote: > 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]