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
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