Re: remove trailing character

2005-03-10 Thread Greg Fortune 
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 HanedaTel: 415.898.2602
>  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]

RE: remove trailing character

2005-03-10 Thread Bessares, Bob 
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 HanedaTel: 415.898.2602
 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]