Get main entities if some data exists in pivot

I have three tables: articles tags article_tags

article_tags is a pivot table, which connect article_id and tag_id.

So i need to retrieve articles which contains specific tag. How i can do it? Thank you.

Best Answer

Level 80

@byvlad Use the whereHas() method:

$articles = Article::whereHas('tags', function ($tag) {
    $tag->where('name', '=', 'foo');
})->get();

1 like

Please or to participate in this conversation.