Answer the question
In order to leave comments, you need to log in
How to search by JSON type field?
There is a data type:
there is a JSON field employees in the following format: [
{
"id": 1,
"name": "Garina Irina Petrovna"
},
{
"id": 2,
"name": "Ivanov Ivan Ivanovich"
}
]
SELECT
*
FROM
`items`
WHERE
`employees`->>"$.id"= 1
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question