SELECT * FROM page where url like '%baidu%' or title like '%baidu%' or like '' ORDER BY CHARINDEX('baidu', url) DESC, CHARINDEX('baidu', title) DESC, CHARINDEX('baidu', body) DESC
select a.[id],a.mark from ( select [page].[id],100 as mark from [page] where [page].[url] like '%baidu%' union select [page].[id],50 as mark from [page] where [page].[title] like '%baidu%' union select [page].[id],10 as mark from [page] where [page].[body] like '%baidu%' ) as a order by mark desc