Update query for XML tag values

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.

 

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.

 

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

:thinking:

 

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