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
>
> -Original Message-
> From: [EMAIL PROTECT
> 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 contents in a column of one tab
