Select top 6 * from Table where id<>100 and (title like '%标题关键词1%' or title like '%标题关键词2%') order by Hits desc,id desc
把或关系的用括号括起来就好了,如同四则运算,括号内优先,否则会因为逻辑关系错误导致查出的数据不正确
用括号括起来。