This series covers how to solve common problems on JSON datasets with MySQL and it includes (links will appear once the target pages are up):
Common JSON questions
- How to extract a field from a JSON object in MySQL?
- How to extract an item from an array in a JSON object in MySQL?
- How to get the JSON field types in MySQL?