为什么 Laravel 中 in 查询只支持 whereIn () 这种写法呢？

$where[] = [ 'in' => ['id' => [1,2,3] ] ]

@tom2333 还有这么骚的操作？？哈哈

@tom2333 好像不对呀，我这边试一下还是不行，只能搜索出‘’1“对应的记录，后面的还是没有查出来的

@tom2333 无效 laravel5.7

laravel5.8 无效

$where['in'] = []; $where['in']['sub_order_id'] = $subOrderIds;

$in = []; if (isset($where['in'])) { $in = $where['in']; unset($where['in']); } $query = $this->dbDomain->table(self::TABLE) ->where($where); if (!empty($in)) { foreach ($in as $name => $value) { $query->whereIn($name, $value); } } $query->where(self::COL_IS_DELETED, "=", 0) ->orderBy(self::COL_CREATED_TIME, 'desc'); $total = $query->count(); if ($page != 0) { $query->forPage($page, $pageSize); } $subOrders = $query->get($columns)->all();

因为优雅的laravel觉得你会觉得这样不优雅

$where[] = [ function ($query) use ($id) { $query->whereIn('id', $id); }, ];

$where[] = [function($q)use($ids){ $q->whereIn('id',$ids); }];