https://gasparsabater.com/laravel-eloquent-ordenar-wherein-orderbyraw-mysql

eloquent-ordered-whereIn.php

<?

// Query Posts 3, 5, 22 and 7
$ids = [3, 5, 22, 7];
$ordered = implode(',', $ids);

$items = \App\Post::whereIn('id', $ids)
    ->orderByRaw(DB::raw("FIELD(id, $ordered)"))
    ->get();

eloquent-where-whereIn.php

<?

// Get all orders since January
// and get first the ones that need to be edited

$orders = DB::table('orders')
    ->where('created_at', '>', '2019-01-01')
    ->orderByRaw('updated_at - created_at DESC')
    ->get();

// Query would be
/*
select * from orders 
    where created_at > '2019-01-01' 
    order by (updated_at - created_at) DESC
*/

eloquent-whereIn.php

<?

// Query Posts 3, 5, 22 and 7 in the same order
$ids = [3, 5, 22, 7];

$items = \App\Post::whereIn('id', $ids)
    ->get();