TP3.2中请问下面的sql中如何将and 替换成OR?

浏览:1210 发布日期:2018/08/31 分类:求助交流
想将AND 换成 OR,但不知如何写

输出的SQL语句:
string(157) "SELECT * FROM `zhenbao_page` WHERE `parent_id` IN ('12') AND ( ( `department_id` IN ('1') AND `department_id` IN ('') ) ) ORDER BY sort,id desc LIMIT 0,4 "

代码:
$where2['parent_id']=array('in',$id);
$where2['department_id']=array([['in',session('did')],['in','']]);

$list = M('page')->fetchSql()->where($where2)->order('sort,id desc')->select();
最佳答案
评论( 相关
后面还有条评论,点击查看>>