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.