SQL query to retrieve results from an array of objects

Viewed 27

I am trying to find a SQL query to retrieve results if an id(for ex:21) is available in an array of objects [{id:21, verify:true}, {id:22, verify:false}] stored in Data column

Table A

Count|Data
E 1  |[{id:21, verify:true}, {id:22, verify:false}]

Select * from A where Data = 21
0 Answers
Related