您可能还对以下相关命理知识感兴趣: select top 30 dbo.SearchKeywordMatch(Title,'身份证号测试') as SearchKeywordMatch,id,tid,Html,title,Hits,Inputdate from Article where convert(varchar(4),Inputdate,120)>'2009' and BChecked=1 and ( Keywords+Title like '%身份%' or Keywords+Title like '%份证%' or Keywords+Title like '%证号%' or Keywords+Title like '%号测%' or Keywords+Title like '%测试%' ) order by SearchKeywordMatch desc,ID desc |