blocks|key|84632|text|使用Logical+Grouping+(Laravel+7.x/4.2)。对于您的示例，应该是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|84633|Model::where(function+($query)+{
++++$query->where('a',+'=',+1)
++++++++++->orWhere('b',+'=',+1);
})->where(function+($query)+{
++++$query->where('c',+'=',+1)
++++++++++->orWhere('d',+'=',+1);
});|code-block|syntax|javascript|84634|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/master/queries#logical-grouping|1|https://laravel.com/docs/7.x/queries#parameter-grouping|2|https://laravel.com/docs/4.2/queries#advanced-wheres^0|2|G|0|S|3|1|W|3|2|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]|$A|Y|B|Z|1|10]|$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]|Q|$5|L|M|N|C|$O|R]]|S|$5|L|M|N|C|$O|T]]]]

Make use of <a href="https://laravel.com/docs/master/queries#logical-grouping" rel="nofollow noreferrer">Logical Grouping</a> (Laravel <a href="https://laravel.com/docs/7.x/queries#parameter-grouping" rel="nofollow noreferrer">7.x</a>/<a href="https://laravel.com/docs/4.2/queries#advanced-wheres" rel="nofollow noreferrer">4.2</a>). For your example, it'd be something like this:
<pre><code>Model::where(function ($query) {
 $query-&gt;where('a', '=', 1)
 -&gt;orWhere('b', '=', 1);
})-&gt;where(function ($query) {
 $query-&gt;where('c', '=', 1)
 -&gt;orWhere('d', '=', 1);
});
</code></pre>

blocks|key|84654|text|如果你想在Laravel+4中使用a，b，c，d的参数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84655|Model::where(function+($query)+use+($a,$b)+{
++++$query->where('a',+'=',+$a)
++++++++++->orWhere('b',+'=',+$b);
})
->where(function+($query)+use+($c,$d)+{
++++$query->where('c',+'=',+$c)
++++++++++->orWhere('d',+'=',+$d);
});|code-block|syntax|javascript|84656|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you want to use parameters for a,b,c,d in Laravel 4

<pre><code>Model::where(function ($query) use ($a,$b) {
 $query-&gt;where('a', '=', $a)
 -&gt;orWhere('b', '=', $b);
})
-&gt;where(function ($query) use ($c,$d) {
 $query-&gt;where('c', '=', $c)
 -&gt;orWhere('d', '=', $d);
});
</code></pre>

blocks|key|302142|text|如果你循环OR条件，你不需要第二个$查询->+where从其他帖子(实际上我不认为你一般需要，你可以在嵌套的where中使用orWhere，如果更容易)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302143|$attributes+=+['first'=>'a','second'=>'b'];

$query->where(function+($query)+use+($attributes)+
{
++++foreach+($attributes+as+$key=>value)
++++{
++++++++//you+can+use+orWhere+the+first+time,+doesn't+need+to+be+->where
++++++++$query->orWhere($key,$value);
++++}
});|code-block|syntax|javascript|302144|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Incase you're looping the OR conditions, you don't need the the second $query->where from the other posts (actually I don't think you need in general, you can just use orWhere in the nested where if easier)

<pre><code>$attributes = ['first'=&gt;'a','second'=&gt;'b'];

$query-&gt;where(function ($query) use ($attributes) 
{
 foreach ($attributes as $key=&gt;value)
 {
 //you can use orWhere the first time, doesn't need to be -&gt;where
 $query-&gt;orWhere($key,$value);
 }
});
</code></pre>

blocks|key|84783|text|如果您想在laravel+4中使用括号，并且不要忘记返回|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84784|在Larave4中(至少)，您需要在括号中使用$a，$b，如示例中所示|84785|$a+=+1;
$b+=+1;
$c+=+1;
$d+=+1;
Model::where(function+($query)+use+($a,+$b)+{
++++return+$query->where('a',+'=',+$a)
++++++++++->orWhere('b',+'=',+$b);
})->where(function+($query)+use+($c,+$d)+{
++++return+$query->where('c',+'=',+$c)
++++++++++->orWhere('d',+'=',+$d);
});|code-block|syntax|javascript|84786|这是我的结果：|84787|📷|atomic|offset|length|84788|​|84789|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9dc3d7c26120d63909fe8e4275b495bd.jpeg|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|14|8|@]|9|@$N|15|O|16|1|17]]|A|$]]|$1|P|3|Q|5|6|7|18|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

if you want to use parentheses in laravel 4 and don't forget return 
In Laravel 4 (at least) you need to use $a, $b in parentheses as in the example

<pre class="lang-php prettyprint-override"><code>$a = 1;
$b = 1;
$c = 1;
$d = 1;
Model::where(function ($query) use ($a, $b) {
 return $query-&gt;where('a', '=', $a)
 -&gt;orWhere('b', '=', $b);
})-&gt;where(function ($query) use ($c, $d) {
 return $query-&gt;where('c', '=', $c)
 -&gt;orWhere('d', '=', $d);
});
</code></pre>

This is my result:
<a href="https://i.stack.imgur.com/LAvKK.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/LAvKK.jpg" alt="enter image description here"></a>

blocks|key|302195|text|您还可以查询第一个或条件，然后再应用另一个或条件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302196|$model+=+Model::where('a',1)->orWhere('b',1);|code-block|syntax|javascript|302197|现在对该$model变量应用另一个条件|offset|length|style|CODE|302198|$model1+=+$model->where('c',1)->orWhere('d',1)->get();|302199|entityMap^0|0|0|4|6|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can also query the first or condition and later you can apply another or condition

<pre><code>$model = Model::where('a',1)-&gt;orWhere('b',1);
</code></pre>

now apply another condition on that <code>$model</code> variable

<pre><code>$model1 = $model-&gt;where('c',1)-&gt;orWhere('d',1)-&gt;get();
</code></pre>

blocks|key|84888|text|另一种不使用Modal的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84889|数据库:+stocks列:id、name、company_name、exchange_name、status|84890|📷|atomic|offset|length|84891|​|84892|++$name+='aa'
++$stocks+=+DB::table('stocks')
++++++++++++->select('name',+'company_name',+'exchange_name')
++++++++++++->where(function($query)+use+($name)+{
++++++++++++++++$query->where('name',+'like',+'%25'+.+$name+.+'%25')
++++++++++++++++->orWhere('company_name',+'like',+'%25'+.+$name+.+'%25');
++++++++++++})
++++++++++++->Where('status',+'=',+1)
++++++++++++->limit(20)
++++++++++++->get();|code-block|syntax|javascript|84893|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/94feb324a35c8d82e2e0146c0c8be76c.png|imageAlt^0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@$G|11|H|12|1|13]]|A|$]]|$1|I|3|J|5|6|7|14|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|15|8|@]|9|@]|A|$N|O]]|$1|P|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W|X|-4]]]]

Another way without using Modal 

Database: stocks 
Columns:id,name,company_name,exchange_name,status
<a href="https://i.stack.imgur.com/e9UXS.png" rel="noreferrer"><img src="https://i.stack.imgur.com/e9UXS.png" alt="enter image description here"></a>

<pre><code> $name ='aa'
 $stocks = DB::table('stocks')
 -&gt;select('name', 'company_name', 'exchange_name')
 -&gt;where(function($query) use ($name) {
 $query-&gt;where('name', 'like', '%' . $name . '%')
 -&gt;orWhere('company_name', 'like', '%' . $name . '%');
 })
 -&gt;Where('status', '=', 1)
 -&gt;limit(20)
 -&gt;get();
</code></pre>

blocks|key|302170|text|您还可以使用查询作用域来使事情变得更整洁一些，这样您就可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302171|Invoice::where('account',+27)->notPaidAt($date)->get();|code-block|syntax|javascript|302172|然后在你的模型中|302173|public+function+scopeNotPaidAt($query,+$asAt)
{
++++$query+=+$query->where(function+($query)+use+($asAt)+{+
++++++++$query->where('paid',+'=',+'0000-00-00')->orWhere('paid',+'>=',+$asAt);+
++++});
++++return+$query;++++
}|302174|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can also use query scopes to make things a bit tidier, so you can do something like:

<pre><code>Invoice::where('account', 27)-&gt;notPaidAt($date)-&gt;get();
</code></pre>

Then in your model 

<pre><code>public function scopeNotPaidAt($query, $asAt)
{
 $query = $query-&gt;where(function ($query) use ($asAt) { 
 $query-&gt;where('paid', '=', '0000-00-00')-&gt;orWhere('paid', '&gt;=', $asAt); 
 });
 return $query; 
}
</code></pre>

blocks|key|84796|text|YourModel::where(function+($query)+use($a,$b)+{
++++$query->where('a','=',$a)
++++++++++->orWhere('b','=',+$b);
})->where(function+($query)+use+($c,$d)+{
++++$query->where('c','=',$c)
++++++++++->orWhere('d','=',$d);
});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|84797|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>YourModel::where(function ($query) use($a,$b) {
 $query-&gt;where('a','=',$a)
 -&gt;orWhere('b','=', $b);
})-&gt;where(function ($query) use ($c,$d) {
 $query-&gt;where('c','=',$c)
 -&gt;orWhere('d','=',$d);
});
</code></pre>

blocks|key|84938|text|这对我很管用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84939|$business+=+Model::where('model_id',+$model_id1)->orWhere('model_id',+$model_id2)->first();|code-block|syntax|javascript|84940|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This works for me
<pre><code>$business = Model::where('model_id', $model_id1)-&gt;orWhere('model_id', $model_id2)-&gt;first();
</code></pre>

blocks|key|302414|text|您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302415|Model::where('table_column',+'value')->orWhere('table_column',+'value')->get()|code-block|syntax|javascript|302416|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use:
<pre><code>Model::where('table_column', 'value')-&gt;orWhere('table_column', 'value')-&gt;get()
</code></pre>

blocks|key|302383|text|对于能言善辩的查询生成器，以下查询将不起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302384|MODELNAME::where('a',+1)->orWhere('b',+1)->where('c',+1)->orWhere('d',+1);|code-block|syntax|javascript|302385|但是你可以使用下面的代码：|302386|MODELNAME::where(function($a)+{
++++$a->where('a',+1)->orWhere('b',+1);
})->where(function($a)+{
++++$a->where('c',+1)->orWhere('d',+1);
});|302387|您可以使用第二个查询，它将完美地工作。|302388|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For eloquent query builder the following query will not work:
<pre><code>MODELNAME::where('a', 1)-&gt;orWhere('b', 1)-&gt;where('c', 1)-&gt;orWhere('d', 1);
</code></pre>
But you can use this code:
<pre><code>MODELNAME::where(function($a) {
 $a-&gt;where('a', 1)-&gt;orWhere('b', 1);
})-&gt;where(function($a) {
 $a-&gt;where('c', 1)-&gt;orWhere('d', 1);
});
</code></pre>
You can use the second query and it will work perfectly.

How do I say <code>WHERE (a = 1 OR b =1 ) AND (c = 1 OR d = 1)</code>

For more complicated queries am I supposed to use raw SQL?

Laravel 4 Eloquent Query Using WHERE with OR AND OR?

数据库

我怎么说WHERE (a = 1 OR b =1 ) AND (c = 1 OR d = 1)？对于更复杂的查询，我是否应该使用原始SQL？

问Laravel 4雄辩的查询使用WHERE with OR和OR？
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 4雄辩的查询使用WHERE with OR和OR？EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 4雄辩的查询使用WHERE with OR和OR？
EN