How to perform nested column query of type JSON

0

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

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

How do I make a query, to know for example if supMaxima is greater than or equal to a certain value?

    
asked by anonymous 23.10.2017 / 16:49

0 answers