Laravel 9.37 has a new rawValue() method to get a value from a SQL expression. Here are some examples from the pull request:
$first = TripModel::orderBy('date_at', 'ASC') ->rawValue('YEAR(`date_at`)');$last = TripModel::orderBy('date_at', 'DESC') ->rawValue('YEAR(`date_at`)'); $fullname = UserModel::where('id', $id) ->rawValue('CONCAT(`first_name`, " ", `last_name`)');
Tip given by @LoydRG
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
[NEW] 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