模糊查询排序问题

[xxsoft]

declare @keyword varchar(50)
set @keyword = 'sh'
select * from testft where contains(username, @keyword)

结果要以 keyword 出现在频率从大到小排列，怎样写where 后面的？

[eddy8863]

select * from testft where username like %sh

[eddy8863]

select * from testft where username like %sh%

[eddy8863]

select * from testft where username like '%sh%'

[xxsoft]

老兄，你没理解到我的意思哦。。

declare @keyword varchar(50)
set @keyword = 'sh'
select * from testft where contains(username, @keyword)

结果要以 keyword 出现在频率从大到小排列，怎样写where 后面的？

我是建立了全文检索，现在要对username 这个字段搜索， 检索出来的结果要以 该字段出现这个
关键字次数最多到最少进行排序！

[dulei115]

declare @keyword varchar(50)
set @keyword = 'sh'
select *
from testft
where contains(username, @keyword)
--试试这个
order by len(username) - len(replace(username, @keyword, '')) desc

[dulei115]

declare @keyword varchar(50)
set @keyword = 'abc'
select *
from testft
where username like '%' + @keyword + '%'
order by len(username) - len(replace(username, @keyword, '')) desc

[dulei115]

--测试通过
if object_id('testft') is not null drop table testft
go
select 'bbbshbcdefg' as username
into testft
union select 'aaashbcshbc'
union select 'defgshhhshsh'

declare @keyword varchar(50)
set @keyword = 'sh'
select *
from testft
where username like '%' + @keyword + '%'
order by len(username) - len(replace(username, @keyword, '')) desc
/*
username
------------
defgshhhshsh
aaashbcshbc
bbbshbcdefg
*/
drop table testft

[xxsoft]

谢谢！通过