Sort by deep JSON column

Asked

Viewed 56 times

2

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

mysql json order-by
No answers

Browser other questions tagged mysql json order-by

You are not signed in. Login or sign up in order to post.