Is there a way to use MySQL's JSON_EXTRACT with integer keys in JSON string?

Question

Is it possible to use JSON_EXTRACT with integer keys?

I want to extract [273, 140] from below, but the SQL does not work ...

SELECT json_extract('{"1": [273, 140], "2": [273.5, 198.5], "3": [209, 191]}', '$.1');

I am trying to use syntax from https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#operator_json-column-path

I get error:

ERROR 3143 (42000): Invalid JSON path expression. 
The error is around character position 3

dev.mysql.com/doc/refman/5.7/en/…

LMC
– LMC

2018-01-26 23:35:56 +00:00
Commented Jan 26, 2018 at 23:35 — LMC
– LMC, Commented Jan 26, 2018 at 23:35

Shubham Bansal · Accepted Answer · 2018-04-11 17:55:41Z

11

You should use double quotes around the key if it is a number. This works:

select json_extract('{"1": [273, 140], "2": [273.5, 198.5], "3": [209, 191]}', '$."1"');

answered Apr 11, 2018 at 17:55

Shubham Bansal

3985 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stefan Crain Over a year ago

While this code snippet may solve the question, including an explanation helps to improve the quality of your response. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion.

Collectives™ on Stack Overflow

Is there a way to use MySQL's JSON_EXTRACT with integer keys in JSON string?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related