In the Laravel 5 I can find all posts that have at least one comment using has
method:
// Retrieve all posts that have at least one comment...
$posts = App\Post::has('comments')->get();
As theres no method like notHas
, how can I find all posts that have no comments?
(remembering that it's a hasMany
relationship)
Reference:
Querying Relationship Existence
http://laravel.com/docs/5.1/eloquent-relationships#querying-relations
There isn't a notHas() method as far as I'm aware, but finding records with a relationship count less than one usually satisfies this requirement:
$posts = App\Post::has('comments', '<', 1)->get();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With