The sole() method will return only one record that matches the criteria. If no such entry is found, then a NoRecordsFoundException will be thrown. If multiple records are found, then a MultipleRecordsFoundException will be thrown.
DB::table('products')->where('ref', '#123')->sole();Tip given by @PascalBaljet
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
Laravel 12 For Beginners: Your First Project
15 lessons
1 h 32 min
Claude Code for Laravel Projects: Crash Course
8 lessons
48 min
Laravel HTTP Client and 3rd-Party APIs
7 lessons
50 min