RE: String substitution in MYSQL

2004-07-26 Thread Adaikalavan Ramasamy
-26 at 14:07, Victor Pendleton wrote: > 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

RE: String substitution in MYSQL

2004-07-26 Thread Victor Pendleton
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

String substitution in MYSQL

2004-07-26 Thread Adaikalavan Ramasamy
I am looking for a string substitution command in MYSQL and was wondering if anyone can help me. Searching the archives was not fruitful. Here is an example : CREATE TABLE tbl (id INT(2), names VARCHAR(20)); INSERT INTO tbl VALUES (1, 'aaa'); INSERT INTO tbl VALUES (2, 'bbb; aaa; ccc'); SE