Unable to search in Mysql json object
Posted by:
Alok Mali
Date: February 01, 2018 06:13AM
Hello Everyone,
I would like to get all rows where id is greater than some value and starttime is less than some value.
The JSONs are in schedule column (JSON type) of a table
{"1":{"id":"1","startdate":"Wed Jan 31 2018","startdateformatted":"2018-01-31","enddate":"Wed Jan 31 2018","instructor":"3","status":"8","starttime":"18:15:00","endtime":"19:15:00"}}
{"1":{"id":"1","startdate":"Wed Jan 31 2018","startdateformatted":"2018-01-31","enddate":"Wed Jan 31 2018","instructor":"3","status":"8","starttime":"18:15:00","endtime":"19:15:00"},"2":{"id":"2","startdate":"Wed Jan 31 2018","startdateformatted":"2018-01-31","enddate":"Wed Jan 31 2018","instructor":"5","status":"8","starttime":"18:15:00","endtime":"19:15:00"}}
Is there any way to achieve it ?
Thanks