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