I need help, please

Sterling94 posted 3 months ago in General

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!!

kapitannwel posted 2 months ago

can you please try this:

SELECT LOWER(data) AS MyAlias FROM MyTable

Please login to leave a reply, or register at first.