I have JSON with a similar structure in MySQL database.
{
"name": "Signature",
"key": "Signature",
"children": [
{
"name": "Signature",
"key": "Signature"
},
{
"name": "SignerUUID",
"key": "SignerUUID"
}
]
}
I want to update the value against the name field inside the children JSON for key Signature like below
{
"name": "Signature",
"key": "Signature",
"children": [
{
"name": "SignHere",
"key": "Signature"
},
{
"name": "SignerUUID",
"key": "SignerUUID"
}
]
}
How can I update the above value in an efficient way?