mysql Extract json element from array

Question

I need to extract JSON element by index e.g.

SELECT JSON_EXTRACT('[{"featureId":"a","read":1,"write":1,"delete":1},{"featureId":"2","read":1,"write":0,"delete":1}]', '$[0].*');

But it just extracts the values I want extracted part to be like this:

{
    "featureId": "a",
    "read": 1,
    "write": 1,
    "delete": 1
}

You can use select JSON_OBJECT('[{"featureId":"a","read":1,"write":1,"delete":1},{"featureId":"2","read":1,"write":0,"delete":1}]', '$[0].*'); — Gaurav
– Gaurav, Commented Mar 2, 2018 at 6:31

wchiquito · Accepted Answer · 2018-03-02 06:51:24Z

1

Try:

SELECT JSON_EXTRACT('
  [
    {"featureId":"a","read":1,"write":1,"delete":1},
    {"featureId":"2","read":1,"write":0,"delete":1}
  ]
', '$[0]');

answered Mar 2, 2018 at 6:51

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

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

1 Answer 1