laravel 使用 json 查询相关的操作

1.全等查询

$query->whereJsonContains('condition', ['level'=>$params['join_level']]);
// 备注：condition数据：[{"fee": 1000, "level": 0, "point": "1", "other_name": "全部"}]

2.like 查询

$query->where('service_subscribe_order.snapshot->service->service_name', 'LIKE', "%{$keyword}%");
// 备注：snapshot结构：{"service":{"service_name":"aa"}}

3.in 查询

$query->whereIn('service_subscribe_order.snapshot->service->id',[11111]);
// 备注：snapshot 结构：{"service":{"id": 11111}}