

Json Array object search key value Mysql
How to search JSON array in MySQL?
How to search JSON array in MySQL?
Get json array key value query -
SELECT 1 AS id, '[{"name": "aman"}, {"name": "jay"}]' AS arr
Example to fetch json array object
SELECT JSON_CONTAINS(arr, '{"name": "jay"}') from test WHERE id=1;
JSON_CONTAINS(arr, '{"name": "jay"}') 1
Syntax
The syntax goes like this:
JSON_CONTAINS(target, candidate[, path]) JSON_CONTAINS will return output in 1 or 0
Share:
1 Comments
Nikhilsays Dec 07
[email protected]
9529921038
nikhil sharma
Leave a reply