Thank you all for your reply, it works perfectly. Gael
Victor Pendleton <[EMAIL PROTECTED]> wrote on 21/05/2004 16.55.23: > One option: > > UPDATE table_name > SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com') > WHERE <some_restriction> > > -----Original Message----- > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Sent: 5/21/04 9:23 AM > Subject: question on data manipulation > > > > > > > Hi All > > I've xml contents in a column of one table. Inside that xml content, > I've > sometime an hardcoded link which I needs to change automatically (lets > say: > from host.domain.com/dev to host2.domain.com) > > I'm searching how to build the sql statement to do it but I don't > understand > how to do this manipulation. > > Any pointer would be appreciated > > Thanks > > gael > > > -- > 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]