在开发中,我们会碰到把数组作为模糊的查询条件,像下面的数组:
$chamber_arr = [2,3,4]
把上面的数据构造模糊查询条件如下:
$where = '1=1'; $where .= " and (chamber like '".implode('%" or chamber like "',$chamber_arr)."%')";
输出结果:
使用 echo 输出
1=1 and (chamber like '2%" or chamber like "3%" or chamber like "4%')