Thank you ! Works like a charm. Here is the successful syntax
UPDATE tbl SET names = REPLACE(names, 'aaa', 'zzz');
I found this link to be quite useful
http://www.jayallen.org/journey/2004/04/how_to_perform_a_mysql_search_and_replace
Regards, Adai.
On Mon, 2004-07-26 at 14:07, Victor Pendlet
Try using the REPLACE command.
-Original Message-
From: Adaikalavan Ramasamy
To: [EMAIL PROTECTED]
Sent: 7/26/04 8:04 AM
Subject: String substitution in MYSQL
I am looking for a string substitution command in MYSQL and was
wondering if anyone can help me. Searching the archives was not
fr
