3.2.3 - 严重 - 已关闭
//查询条件组装
$where['usertype'] = 1;
if(!empty($data)){
foreach($data as $key=>$vue){
$where[$key] = ['like',trim('%'.$vue.'%')];
}
}但是$vue 就是in也就是说 我要查的是 username like '%in%' 这样的
连贯操作后出现bug,
SELECT * FROM `yy_user` WHERE `usertype` = 1 AND `username` LIKE '%in %' ORDER BY id ASC LIMIT 0,20 LIKE 中多了一个空格,导致查询错误 