sorry I'm a beginner in coding. I have a set of json array consisting of more than 100 variables. here's the example of the few data:
{"noreg":"643758","norm":"655","nama":"cindy minato ishii","normunit":"vm7546","tglreg":"02-04-2020","alamat":"yujeyuo prefecture, thaikhan st. 467, tokyo, japan","tgllahir":"30-04-1964","umur":"56","gender":"P","agama":"shinto","tglcu":"10-04-2020","pekerjaan":"vampire","paket":"GOLD"}
How can I iterate through, let's say: only from "noreg" variable through "alamat" variable, with looping? From far what I'm doing is this:
SELECT JSON_EXTRACT(xxx, '$.nama') AS nama,
.....
.....
.....
JSON_EXTRACT(mcu_data, '$.alamat') AS alamat
FROM xxx
WHERE xxx
I'm tired in doing all the JSON_EXTRACT for = the amount of the data I need. Let's say 50. Then, I have to repeat that 50 times. Any solution will be so helpful.