現(xiàn)在數(shù)據(jù)庫(kù)里面有一堆數(shù)據(jù)
1,2,3,
2,4,1,11,
111,1,31,
3,11,
我想要的效果是把1,去掉 下面用到了正則匹配
#先通過(guò)sql語(yǔ)句把帶1,的查找出來(lái)
#在通過(guò)foreach循環(huán)處理
$tab = M('tab')->where('aid like "%1,%" or aid like "%,1,%"')->select();
foreach($tab as $k=>$v){
$aid = preg_replace("/,1,/",",",$tab[$k]['aid']);
$aid = preg_replace("/^1,/","",$aid);
echo $aid;
}
END
