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.