$wz=new Article();
if(isset($lista)){
foreach (explode(",", $lista) as $value){
$value!=""?$wz=$wz->whereOr('columns','like',"%".$value."%"):"";
}
}
$list=$wz->where('columnb',1)->paginate(8);
运行时生成以下的sql语句，执行是不正常的
SELECT DISTINCT * FROM `article` WHERE `columns` LIKE '%1%' OR `columns` LIKE '%2%' AND `columnb` = 1 ORDER BY `createdate` DESC LIMIT 0,8
下面这样的就正常了，请问这个怎么弄哦
SELECT DISTINCT * FROM `article` WHERE (`columns` LIKE '%1%' OR `columns` LIKE '%2%') AND `columnb` = 1 ORDER BY `createdate` DESC LIMIT 0,8
最佳答案
