$where =" aa LIKE aaa";$where =" aa IN (1,2,3,4)";我习惯这么写

回复迅睿框架创始人好吧，，，，

回复迅睿框架创始人但是我有多个条件，这样是只有一个字符串啊

最效率的就是一楼老大的写法，因为这是最原始的sql语法，你再怎么包装只会给程序多走弯路，因为SQL最终还是会以这种写法来运行SQL，

易学习我一次有多个条件，只有只能有一个啊，字符串

$where =" aa IN (1,2,3,4) and bbb IN(2,3,4)";

易学习太不灵活了

@琉惗：if ($key['type'] == 'Checkbox' || $key['type'] == 'Linkages'){ $where[] = "`".$key['name']."` = '".$key['value']."'"; }elseif ($key['type'] == 'Linkage' || $key['type'] == 'Radio' || $key['type'] == 'Select'){ $where[] = "`".$key['name']."` = '".$key['value']."'"; }else{ $where[] = "`".$key['name']."` like '%".$key['value']."%'"; }