I need help, please

[expired user #11739]'s profile image [expired user #11739] posted 6 years ago in General Permalink

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's profile image kapitannwel posted 6 years ago Permalink

can you please try this:

SELECT LOWER(data) AS MyAlias FROM MyTable

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