There was an interesting question on Stackoverflow.com on
extracting values from a JSON data type column in a MySQL
database. What caught my eye was the the keys for the
key/value pairs were numeric. In particular the author of the
question only wanted values for the key named 74.
The sample data was fairly simple.
{ "70" : "Apple", "71" : "Peach", "74" : "Kiwi" }
I thought SELECT JSON_EXTRACT(column, '$.74') FROM table;
should work but it did not. There was a complaint about an
invalid path expression.
It turns out that you need to make the second argument in the
function '$."74"' or SELECT JSON_EXTRACT(column,'$."74"') FROM
table;
File this under something to remember for later. :-)
Showing entries 1 to 1
May
22
2018
Showing entries 1 to 1