Sort by deep JSON column

Question

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 who ordains by "value" when the "name" (key JSON within the Array) for name (value), that is, name of the person concerned.

How could I do that? It’s possible? Mysql 5.7.19