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