laravel的in查询_laravel 模型查询按照whereIn排序的示例

实例如下所示：

$ids = [5,7,3,1,2];

$data = Content::whereIn('id',$ids)

->select('id')

->get();

//查询结果是想按照wherein的顺序排序

//正确写法

$data = Content::whereIn('id',$ids)

->select('id')

// ->orderBy(\DB::raw('FIND_IN_SET(id, "' . implode(",", $ids) . '"' . ")"))

// ->orderBy(DB::raw("FIND_IN_SET(id, '" . implode(',', $ids) . "'" . ')'))

// ->orderByRaw("FIND_IN_SET(id, '" . implode(',', $ids) . "'" . ')')

->orderBy(\DB::raw('FIND_IN_SET(id, "' . implode(",", $ids) . '"' . ")"))

->get();

中午没睡觉一直调试，心塞...

错误写法

//错误写法

$data = Content::whereIn('id',$ids)

->selec