thinkPHP mysql查询 where条件 A and (B or C)

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

文章目录

• 前言
• 一、where A and (B or C)    
• 二、where (A or B) or (C and D)  
• 总结

---

前言

thinkPHP中MySQL查询where条件的and or

一、where A and (B or C)

$condition['A']='A';
$conditionOr['B']='B';
$conditionOr['C']='C';
db()->where($condition)
    ->where(function ($query) use ($conditionOr) {
                $query->whereOr($conditionOr);
    })
    ->select();

二、where (A or B) or (C and D)

$condition['A']='A';
$condition['B']='B';
$conditionOr['C']='C';
$conditionOr['D']='D';
db()->where(function ($query) use ($condition) {
                    	$query->whereOr($condition);
                	})
    ->whereOr(function ($query) use ($conditionOr) {
                $query->where($conditionOr);
    })
    ->select();

---

总结