把字符串$str="abs,er,ccv,sf,fsaf,fsdf"; 替换成 $str="'abs','er','ccv','sf','fsaf','fsdf'"; 然后用where keystr in ($str) 来查询
$str="'abs','er','ccv','sf','fsaf','fsdf'";假如一条数据字段keystr中为"abs,er,ccv,sf,"Select * From Table1 Where keystr in ($str) 这样是读不出来的
我想like可以吧?虽然有点慢!可总比不出来好多了!
试试这个:$sql="SELECT * FROM `table1` where keystr regexp ".'.*'.str_replace(',','.*|.*',$str).'.*';替换后得sql类似是这样的: SELECT * FROM `table1` where where str1 regexp '.*abs.*|.*er.*'速度不会快
替换成 $str="'abs','er','ccv','sf','fsaf','fsdf'";
然后用where keystr in ($str) 来查询
试试这个:$sql="SELECT * FROM `table1` where keystr regexp ".'.*'.str_replace(',','.*|.*',$str).'.*';替换后得sql类似是这样的:
SELECT * FROM `table1` where
where str1 regexp '.*abs.*|.*er.*'速度不会快