Where relationship column equals?

Question

I am trying to grab all records where Player's relationship called stats() has a column value of something. I would usually do ::where('column_name' 'column_value') for the players table, but how can I get ::where the relationship table's column equals to something?

Player::where('column_name', 'column_value')->get();

But I want to check a column in the relationships table?

public function roleplay()
{
    return $this->hasOne('App\Database\Frontend\User\Roleplay', 'user_id', 'id');
}

Check this section in Laravel's documentation: https://laravel.com/docs/5.4/eloquent-relationships#querying-relationship-existence — Eduardo Pacios, Mar 29 '17 at 23:31

score 91 · Accepted Answer · edited Apr 08 '20 at 06:44

91

This will filter Player based on a related table

Player::whereHas('roleplay', function($q){
   $q->where('column_name', 'value');
})->get();

edited Apr 08 '20 at 06:44

usrNotFound

2,680
3
25
41

answered Mar 29 '17 at 23:31

oseintow

7,221
3
26
31

Thanks, this was the ticket! – Josh Mar 26 '21 at 16:03

score 20 · Answer 2 · answered Feb 20 '22 at 22:32

20

Laravel 8^ : doc Relationship Existence Queries

Product::with('categoreys')->whereRelation('categoreys', 'status', '0')
                                            ->get();

answered Feb 20 '22 at 22:32

ali hassan

321
2
5

2

That's just a shortened way of writing of @oseintow's answer – Epoc Mar 29 '22 at 16:02
1

Please note that by using `with` two database queries will be executed. The accepted answer that uses `whereHas` will result in a single query. – Robin Sep 14 '22 at 14:46
It's a good (or at least 'clean') way for nested relationships. Thanks. – Rouhollah Mazarei Jul 30 '23 at 10:21

Where relationship column equals?

2 Answers2