I have JSON data stored in MariaDB in a column having data type as TEXT.
Examples of 4 rows in JSON_Column of table My_Table are:
Table Row 1:
[New Values: {PSTN=0/34/25}] [Old Values: {PSTN=0/31/25/0}]
Table Row 2:
[New Values: {PASSWORD=194aa6c17f4ad64f8a38a44cb2c90c63, METHOD=7}] [Old Values: {PASSWORD=626dd7a54f2gfd7834aabbccaabb345ccb, METHOD=0}]
Table Row 3:
[New Values: {STATUS=0}] [Old Values: {STATUS=1}]
Table Row 4:
[New Values: {GROUP=223}] [Old Values: {GROUP=263}]
I am looking for solution to convert this JSON data as rows and columns as below:
Helping to provide expert solution will be highly appreciated.
Thanks and Regards
You need to sign in to view this answers