Fetching object JSON array using JSON_QUERY in MariaDB

Question

How do I access the value of a object property, inside an array, using JSON_QUERY in MariaDB? I have a JSON field with following data, and want to access the value of the section property.

[
  [
    {"section": "search"}
  ]
]

The following SQL is returning NULL

SELECT JSON_QUERY('[[{"section": "search"}]]', '$[0][0].section') FROM mytable

Joyce Babu · Accepted Answer · 2019-05-09 14:04:46Z

4

For anyone else having the same issue, you have to use JSON_VALUE for accessing scalar values. The following query gives the expected result.

SELECT JSON_VALUE'[[{"section": "search"}]]', '$[0][0].section') FROM mytable;

JSON_QUERY vs JSON_VALUE

answered May 9, 2019 at 14:04

Joyce Babu

20.9k13 gold badges66 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Fetching object JSON array using JSON_QUERY in MariaDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related