JSON search in MySQL 5.7?

Question

MySQL

How to select elements where categoriesId = 4
There is a column: depend it stores a JSON array like:
{"brandsId": [145, 15, 141, 1001, 93, 657], "categoriesId": [41, 4, 65, 24, 218, 890]}
I need to find all entries where categoriesId = 4

select * from `services` where `dependencies`->"$.categoriesId" = 4 - не работает

Answer 1

Try like this:

SELECT *
FROM `services`
WHERE JSON_CONTAINS(`dependencies`, '4', '$.categoriesId')