22,300
社区成员




select *
from tb
order by (case when charindex(N'北京',keywords) then 4 else 0 end) +
(case when charindex(N'奥运',keywords) then 3 else 0 end) +
(case when charindex(N'2008',keywords) then 2 else 0 end) +
(case when charindex(N'吉祥物',keywords) then 1 else 0 end)
--没有规则不好弄!