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]
