In our MySql database the data is stored in combined json-strings. The table looks like this:
| ID | DATA |
| 100 | {Var1Str: "sometxt", Var2Double: 0,01, Var3Integer: 1} |
| 101 | {Var3Integer: 5, Var2Double: 2,05, Var1Str: "txt"} |
The result needs to look like this (same (sub)variable names but all lower letters):
| ID | DATA |
| 100 | {var1str: "sometxt", var2double: 0,01, var3integer: 1, var4str: "another text"} |
| 101 | {var3integer: 5, var2double: 2,05, var1str: "txt", var4str: "more text"} |
Help me!!