How to use an extended where clause when using OR operators

How can I create a query that displays user_id 1 who is a member of the club and the subjects that are soccer or tennis or cricket.

id|user_id|member|football|tennis|cricket
1 | 1     |Yes   | 1      | NULL | NULL
2 | 1     |Yes   | NULL   | NULL | NULL
3 | 2     |Yes   | NULL   | 1    | NULL
4 | 3     |Yes   | 1      | 1    | NULL
5 | 1     |No    | NULL   | 1    | NULL
6 | 1     |Yes   | NULL   | 1    | 1

      

So, basically I would like to get the following lines:

id|user_id|member|football|tennis|cricket
1 | 1     |Yes   | 1      | NULL | NULL
6 | 1     |Yes   | NULL   | 1    | 1

      

So far I have this:

$user = Model::where(function ($query) {
    $query->where('cricket', 1)
          ->orWhere('tennis', 1);
          ->orWhere('football', 1);
        })->where(function ($query) {
    $query->where('user_id', '=', 1)
          ->Where('member', '=', 'Yes');
     });

      

+3


source to share


1 answer


Ah, you have joined the ranks of Advanced Where users - welcome!



$user = Model::
    ->where('user_id', 1)
    ->where('member', 'Yes')
    ->where(function($query) {
        $query
            ->where('cricket', 1)
            ->orWhere('tennis', 1);
            ->orWhere('football', 1);
    })
    ->select(['id', 'user_id', 'member', 'football', 'tennis', 'cricket'])
    ->get()
;

      

+5


source







All Articles