How to custom OrderBy in Laravel

user_12455309 0
Viewed 952

I wanted to do a custom ordering for marketing_status_id in this:

$prospect = $this->filterProspect($request->all())
            ->select([
                'student_marketings.*',
                'students.name',
                'students.identification_type_id',
            ])
            ->distinct('student_marketings.id')
            ->orderBy('student_marketings.marketing_status_id');

How to order it in this sequence: ('marketing_status_id', 5, 20, 4, 1, 3, 18, 6) ?

query-builder laravel
1 Answers

Use mysql inbuilt-method field() like this:

$prospect = $this->filterProspect($request->all())
            ->select([
                'student_marketings.*',
                'students.name',
                'students.identification_type_id',
            ])
            ->distinct('student_marketings.id')
            ->orderBy(DB::raw('FIELD(marketing_status_id, 5, 20, 4, 1, 3, 18, 6)'));
user_28730520
Related