Update query

[MuraliDharan V]

Hi all,

My Mysql Version is 5.0,

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

For Ex:
<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>

As MYSQL Version does not supports XML functions and iam in need to do this immediately.

How can update like this?...Help me.

Thanks,
Murali.V