Don’t Filter by NULL in Collections in Laravel
You can filter by NULL in Eloquent, but if you're filtering the collection further - filter by empty string, there's no "null" in that field anymore.
// This works $messages = Message::where('read_at is null')->get();
// Won’t work - will return 0 messages $messages = Message::all(); $unread_messages = $messages->where('read_at is null')->count();
// Will work $unread_messages = $messages->where('read_at', '')->count();