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 to share