How in MySQL to create a select query nested json array?

Question

How in MySQL to create a select query nested json array?

126 views

Hello!
There is json, which is written in the data_json with the type "json" in a MySQL table:

{ "name": "Test", "books": [ { "id": 1 }, { "id": 2 } ] }

How do I make a selection id array books where id = 1?

I tried something like that, but it doesn't work:

SELECT * FROM test WHERE data_json -> "$.books[*].id" = 1

asked Aug 2, 2019 by PendalF89 | 126 views

1 Answer

Related questions

orlov0562 · Answer 1 · 2019-08-06T20:37:27+0000

No, or I don't know how.

The fact that the sample data_json -> "$.books[*].id" return here is the value "[1, 2]" it is incorrect to compare the number.

SELECT data_json -> "$.books[*].id" FROM test

In MySQL 8 have JSON_TABLE, guessing from "[1, 2]" you can make a table and have it build the condition.

How in MySQL to create a select query nested json array?

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Related questions

Most popular tags