0

data:

{"a": {"b": [{"name": "s", "value": "2"}, {"name": "r", "value": "100113"}, {"name": "r", "value": "1121202"}]}}

here is want to get the value when name is "r",

output: value: "100113" "1121202"

what to do using json mysql functions like json_extract,json_search.

0 Answers0