数据库-高级查询

浏览:507 发布日期:2020/12/08 分类:ThinkPHP6专区 关键字: where 数据库 whereOr
$product = Db::table('uni_product');

$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条件?
最佳答案
评论( 相关
后面还有条评论,点击查看>>