How to query on json data ?

plz provide solution i need that query :'( #Jim_Knicely

Maybe the MAPITEMS function can help?

dbadmin=> select maptostring(days) from testing_view;
                                    maptostring
    ---------------------------------------------------------------------------
     {
       "0" : "3",
       "1" : "4",
       "2" : "5",
       "3" : "2",
       "4" : "3"
    }

     {
       "0" : "1",
       "1" : "2",
       "2" : "3",
       "3" : "1",
       "4" : "3"
    }

    (2 rows)

dbadmin=> select values from (select mapitems(days) over(partition best)from testing_view) foo where keys = 4;
 values
--------
 3
 3
(2 rows)

dbadmin=> select values from (select mapitems(days) over(partition best)from testing_view) foo where keys = 0;
 values
--------
 3
 1
(2 rows)

I got the solution

select id from testing where mapcontainsvalue(__raw__['days'],'2')='t' ;

this will give u exact id's which 2 value contains