Laravel 中根据某个特定顺序去排序查出来的数据:FIND_IN_SET

2018-08-01 13:47:41 阅读:7 编辑
  $study_record_items = Lesson::whereIn ("id",$lesson_id_list)->where ('is_show',1)
                ->orderByRaw (\DB::raw ("FIND_IN_SET (id,'" . implode (',', $lesson_id_list) . "'".')'))
                ->get ();