Update query for XML tag values

Windhan's Avatar, Join Date: Jan 2008
Go4Expert Member
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.
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
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.
0
Windhan's Avatar, Join Date: Jan 2008
Go4Expert Member
Can't be this possible with a normal update query with MYSQL String Functions may be inside a Stored Procedure?

0
Windhan's Avatar, Join Date: Jan 2008
Go4Expert Member
If i get a solution for my requirement here....that will be great
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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