數據庫表(T1)中有個字段(pinfos)是這樣保存數據的:[{"subject":"1111222222","postids":"1,3,6,7,9","successdate":"2019-03-04"},{"subject":"3333","postids":"3,9,12","successdate":"2019-03-24"},{"subject":"3333","postids":"1,7","successdate":"2019-04-07"},{"subject":"3333","postids":"1,2,5","successdate":"2019-05-04"}]字段類型為:text這個只是一條記錄中的這個字段里的內容,這個表有N條記錄。需求:想在這個表中,把這個(pinfos)字段中所有successdate小于2019-06-01的的記錄,全部找出來。
添加回答
舉報
0/150
提交
取消