Laravel 中模糊搜索 JSON 数组中的数据的指向问题
{
"items": [
{
"city": "杭州市",
"total": "26.80",
"mileage": "12.6",
"car_type": "快车",
"time_geton": "03-1114:30周五",
"station_geton": "浙江吉桂投资有限公司",
"station_getoff": "杭州火车站"
},
{
"city": "杭州市",
"total": "16.10",
"mileage": "10.1",
"car_type": "快车",
"time_geton": "03-2121:44周-",
"station_geton": "浙江吉桂投资有限公司",
"station_getoff": "金色蓝庭"
}
],
"common": {
"date": "",
"phone": "",
"total": "100",
"date_end": "",
"date_start": ""
}
}
这是我要搜索的json数据,数据库字段名为ocrdata,我如果用where语句搜索common里的字段,用ocrdata->common->total就可以指向,但是如果我想搜索item里的city该怎么指向呢,因为item是个数组,无法一直用->指向下去,我试过ocrdata->items->[*]->total发现无法查到
推荐文章: