Changing the first letter of JSON key to upper case in MySQL table
I have a MySQL JSON field with this content:
{
"fooValue": 0.2,
"BarValue": "string"
}
I would like to change in all rows in a table the key "fooValue" to "FooValue" - if the 1st character is in lower case, otherwise [like "BarValue"] keep the current character. Is there some simple MySQL procedure/function or is there only a solution with MySQL function or direct in PHP iterating through all rows?