laravel orderBy 自定义排序

$xk_whitelist = DB::table('mld_xk_whitelist')
                                ->where(['kh_type' => 1, 'cstm_id' => $member_info->cstm_id])
                                ->orderByRaw(DB::raw('FIELD(type, 2,3,0,1) asc'))
                                ->get()
                                ->toArray();

 

posted @ 2020-11-26 18:24  不一样的开始  阅读(2081)  评论(0编辑  收藏  举报