Consultando un array json en MySQL utilizando MySQL Workbench.
Aquí está mi data JSON: { “TransactionId”: “1”, “PersonApplicant”: [ { “PersonalId”: “1005”, “ApplicantPhone”: [ { “PhoneType”: “LANDLINE”, “PhoneNumber”: “8085063644”, “IsPrimaryPhone”: true } ] }, { “PersonalId”: “1006”, “ApplicantPhone”: [ { “PhoneType”: “LANDLINE”, “PhoneNumber”: “9643645364”, “IsPrimaryPhone”: true }, { “PhoneType”: “HOME”, “PhoneNumber”: “987654321”, “IsPrimaryPhone”: false } ] } ] } . . . Read more