直接上代码: 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
增加体验效果请勿用IE、 本站对IE不友好、 o(∩_∩)o 哈哈