$product->whereOr(
[
[['publish','like',"%" . $user->openId . "%"]]
]
); //先查询自己发表的内容
// // // // //获取到了用户的openId数组,查询用户发表过的产品
for ( $i = 0 ; $i < count($ret) ; $i++ ) {
$product->whereOr(
[
[['publish',"like","%" . $ret[$i]['openId'] . "%"],['look',"like",["%" . $user->openId . "%","%all%"],'OR']]
]);
}
if($search)
{
$product->where('idea|label|name','like','%' . $search . '%');
}
"SELECT * FROM `uni_product` WHERE ( `publish` LIKE '%oQ-Jf5XqJoO5YPJsrlk3IFLoO3EI%' ) OR ( `publish` LIKE '%oQ-Jf5Vx4NHBK0UMvB9KEVr2Z-GU%' AND (`look` LIKE '%oQ-Jf5XqJoO5YPJsrlk3IFLoO3EI%' OR `look` LIKE '%all%') ) OR ( `publish` LIKE '%oQ-Jf5d7HHdxbPqa0XWQgsf0dIUw%' AND (`look` LIKE '%oQ-Jf5XqJoO5YPJsrlk3IFLoO3EI%' OR `look` LIKE '%all%') ) OR ( `publish` LIKE '%oQ-Jf5XztujGSCwPSSwdO381r_18%' AND (`look` LIKE '%oQ-Jf5XqJoO5YPJsrlk3IFLoO3EI%' OR `look` LIKE '%all%') ) AND ( `idea` LIKE '%上班%' OR `label` LIKE '%上班%' OR `name` LIKE '%上班%' ) ORDER BY `timestamp` DESC LIMIT 20"
为什么最后一句AND 没有效果? 多个OR 该如何添加一个AND条件?
最佳答案