[Linux]Mysql中使用正则表达式

<p><br /></p><p>$keyWhere = &quot; where ( instr(keyword,'$kw')&gt;0 or instr(keyword_s,'$kw')&gt;0 or instr(commit,'$kw')&gt;0 or concat('[.*]','$kw','[.*]') REGEXP concat('[.*]',keyword,'[.*]') ) and keyword != '$kw' and type not in ('16') and lang='jp' &quot;;</p><p><br /></p><p>$sqlWhere = &quot; where p.post_title like '%$kw10%' and k.type = '16' and p.post_title REGEXP concat('[^0-9*]',k.keyword,'[^0-9*]') &quot;;</p><p><br /></p><p>http://6duweb.com/278.html</p><br />