[Windhan]

Hi All,

My Mysql Version is 5.0,

I have XML in the table and i want to update a particular tag,

For Ex:
This is my XML,

<order>
<product>
<Item>
Crop
</Item>
.
.
.
.
.
.
<Item>
doe
</Item>
<product>
<order>

Now I update the Item Tag value alone as same product and i need the output as,

<order>
<product>
<Item>
myproduct
</Item>
.
.
.
.
.
.
<Item>
myproduct
</Item>
<product>
<order>

How can update like this?, as my Version does not support XML functions.

[pradeep]

You have to fetch the XML data, process it using a parser if required and the update the table with the new XML data. On-the-fly updation is not possible.

[Windhan]

Can't be this possible with a normal update query with MYSQL String Functions may be inside a Stored Procedure?

[Windhan]

If i get a solution for my requirement here....that will be great

[shabbir]

MySQL does not provide SQL operations but string operation is there but I am not sure that can help unless you have a very good at regular expressions