I use a component (ZOO) with the CMS Joomla to create articles.
The articles have different fields (title, subtitle, text, links, etc.) and the datas are stored in database in a column named "elements" like this :
{
"b7b99652-839b-4171-8b4b-54a20415e459": {
"0": {
"value": "datas i want to copy"
}
},
"8e3a883d-ab97-4091-869e-6189c0450c85": {
"0": {
"value": "here i want to record the datas i want to copy",
"text": "",
"target": "1",
"custom_title": "",
"rel": ""
}
}
}
I would like to copy the value of b7b99652-839b-4171-8b4b-54a20415e459 inside the value of 8e3a883d-ab97-4091-869e-6189c0450c85
I know how to copy datas from one column to another with MySQL but here in don’t know how to do this.
I can't do it manually because i have more than 400 entries like this.