How to retrieve specific field from nested json field in mysql?
I have following column(descrition field) in my table of data in which i have to extract country name field value. like Spain from this field.
[{“key”: “country_code”, “type”: “string”, “value”: “12”}, {“key”: “country_name”, “type”: “string”, “value”: “Spain”}, {“key”: “timezone”, “type”: “string”, “value”: “Europe/Madrid”}, {“key”: “latitude”, “type”: “string”, “value”: “40.37603”}, {“key”: “longitude”, “type”: “string”, “value”: “-3.69901”}]
enter image description here