How to extract values from a numeric-keyed nested JSON field in MySQL

mysql json mysql-json

@Ibrahim,You have an error in your code. If you use number (or spaced words) as key in a JSON data type in MySQL, you'll need to double-quote it.

Therefore, the correct MySQL statement in your case is:

select sent->'$.data."12"' FROM mytable;

Thanks,@JeffreyKilelo

CodeHunter