mysql分词搜索

直接上代码:

select c.id,c.title,l.typename as city,m.typename as `column`,c.updatedate,
((IF( CONCAT_WS(" ", c.title) LIKE "%银行%", 1, 0))
+(IF( CONCAT_WS(" ", c.title) LIKE "%银行上海%", 1, 0))
+(IF( CONCAT_WS(" ", c.title) LIKE "%项目采购公告%", 1, 0))) AS keyweight
 from tb_article as c left join tb_lmtype AS l on c.area=l.id 
left join tb_lmtype AS m on c.typeid=m.id 
where c.id!='' AND c.area=35 AND c.typeid=66 
AND CONCAT_WS(' ', c.title) REGEXP "银行|银行上海|项目采购公告" order by `updatedate` DESC limit 0,10

//根据自己需求修改代码