How to perform nested data query in JSON type column

Asked

Viewed 66 times

0

I have the data (nested) below in a column of type JSON:

[{"modSelecionado": "13"}, {"modSelecionado": "15"}, {"modSelecionado":
 "16"}, {"supMaxima": "5,00", "tensaoMotor": "1", "comunicacaoMotor": "1"}]

How do I perform a query, for example whether supMaxima is greater than or equal to a certain value?

mysql

  • This was not answered in Friday’s question?

  • Hello @LINK, the structure of the data that is stored in the column is different.

  • Try the following: SELECT * FROM Tabela WHERE column->"$. supMaxima" > 5;

  • Hello @Caiqueromero, notice that the structure is different of this, I mean, it doesn’t work. =\

No answers

Browser other questions tagged mysql

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