orderbyraw laravel code example
Example 1: limit laravel
$posts = Post::all()->limit(10)->get();
Example 2: orderby in laravel
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
$inquiries = Inquiry::orderBy('status', 'ASC')
->orderBy('created_at', 'DESC')
->get();
Example 6: laravel 6 orderby
$inquiries = Inquiry::all()->sortByDesc('created_at')->sortByDesc('Status')->values();