Skip to main content
Quick Tip

Pass a raw query to order your results

You can pass a raw query to order your results.

For example, sorting tasks by how long before the due date they were completed.

// Sort tasks by the task was completed before the due date
$tasks = Task::query()
->whereNotNull('completed_at')
->orderByRaw('due_at - completed_at DESC')
->get();

Tip given by @cosmeescobedo

Enjoyed This Tip?

Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.

Recent Courses on Laravel Daily

Mobile Apps: React Native vs Flutter vs NativePHP?

8 lessons
55 min

Next.js Basics for Laravel Developers

11 lessons
58 min

Testing in Laravel 13 For Beginners

26 lessons
1 h 41 min read