To retrieve the Query Builder after filtering the results: you can use ->toQuery().
The method internally use the first model of the collection and a whereKey comparison on the Collection models.
// Retrieve all logged_in users$loggedInUsers = User::where('logged_in', true)->get(); // Filter them using a Collection method or php filtering$nthUsers = $loggedInUsers->nth(3); // You can't do this on the collection$nthUsers->update(/* ... */); // But you can retrieve the Builder using ->toQuery()if ($nthUsers->isNotEmpty()) { $nthUsers->toQuery()->update(/* ... */);}
Tip given by @RBilloir
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
[NEW] Laravel 13 Starter Kit Teams and Customizations
10 lessons
33 min
Queues in Laravel 13
18 lessons
1 h 12 min read
NativePHP v3: Create Mobile Apps with Laravel
10 lessons
1 h 02 min