orderbyraw laravel code example

Example 1: limit laravel

$posts = Post::all()->limit(10)->get();

Example 2: orderby in laravel

/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Http\Response
 */
public function index()
{
    $messages = Message::select("*")
                            ->where('receiver_id',$id)
                            ->orderBy('created_at', 'desc')
                            ->get();
  
    dd($messages);
}

Example 3: laravel order by raw

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

Example 4: laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Example 5: laravel 6 orderby

// Make sure column names are correct
$inquiries = Inquiry::orderBy('status', 'ASC')
    ->orderBy('created_at', 'DESC')
    ->get();

Example 6: laravel 6 orderby

$inquiries = Inquiry::all()->sortByDesc('created_at')->sortByDesc('Status')->values();

Tags:

Sql Example