mysql全文匹配搜索字串中含圆括号()怎么办？

Question

mysql全文匹配搜索字串中含圆括号()怎么办？

Answer 1

<?php$text = "aa;aa;xx;aa;aa;bb;cc;aa;aa";$text .= ';';//字串末尾加上分号preg_match_all ("/aa;/", $text, $out);//匹配aa;echo count($out[0]);//结果在$out[0];中关联UID，你根据你的情况做关联即可。?>

Answer 2

比如查是否有pangyiguangmysql有个函数：FIND_IN_SET1SELECT&nbsp;FIND_IN_SET('pangyiguang','94pangyiguang88');或者你用&nbsp;1select&nbsp;*&nbsp;from&nbsp;tb&nbsp;where&nbsp;filed&nbsp;like&nbsp;'%pangyiguang%';