http://blog.sina.com.cn/s/blog_71261a2d0100wzk9.html
mysql regexp正则表达式


where concat(',',hobby,',') regexp 
    ->   concat(',(',replace('阅读,交友,围棋,足球,滑雪',',','|'),'),'); 


CONCAT(',',REPLACE(fwpt,' ',','),',') REGEXP
CONCAT(',(',replace('12,13,14,15',',','|'),'),');


SELECT fwpt FROM cms_archives_3 a
WHERE CONCAT(' ',a.fwpt,' ') LIKE '% 12 %'
OR CONCAT(' ',a.fwpt,' ') LIKE '% 13 %'
OR CONCAT(' ',a.fwpt,' ') LIKE '% 14 %'
OR CONCAT(' ',a.fwpt,' ') LIKE '% 15 %'
LIMIT 200; 

SELECT fwpt FROM cms_archives_3 a
WHERE CONCAT(' ',a.fwpt,' ') LIKE '% 12 %'
OR CONCAT(' ',a.fwpt,' ') LIKE '% 13 %'
OR CONCAT(' ',a.fwpt,' ') LIKE '% 14 %'
LIMIT 200; 


----------------------------- 

SELECT fwpt FROM cms_archives_3 
WHERE fwpt REGEXP '^(12)$|^(12)\t|\t(12)\t|\t(12)$'
LIMIT 200; 

SELECT fwpt FROM cms_archives_3 a
WHERE CONCAT(' ',a.fwpt,' ') LIKE '% 12 %'
LIMIT 200; 

----------------------------- 
//以下行,可替代foreach，但效率差不多
//$this->searchstr = "CONCAT(',',REPLACE($fpre$fn,'\t',','),',') REGEXP CONCAT(',(',replace('".implode(',',${$fn})."',',','|'),'),')";


-----------------------------