I have a column called data , which has, for example, this JSON
[{"name": "unit", "value": "2", "validator": ["required"]}, {"name": "name", "value": "teste", "validator": ["required"]}]
I need to make a SELECT that orders by "value" when "name" ( key JSON within Array ) is name (value), that is, the name of the person in question.
How could I do this? It's possible? MySQL 5.7.19