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