You should avoid using SQL functions in your Laravel Eloquent queries because they inflict full table scans. This happens due to database mechanisms – the condition is not applied until the date function has been run. It will produce a query like this: The better way: So we get this exact query, without the date() […]