将SQLServer全文搜索限制在前3位

Question

如果这是一件简单的事情，我是一个SQL新手，对不起。

我在sql中的数据如下

我的数据：

Content    sl.no
KTUU Alaskas News Source Alaskas Top News Storm Watch Weather Politics Sports Health Business Headlines 16419
Lawn Care Business Service Providers Lawn Care Business Information Lawn Mowing Companies Lawn Care Directory   17113
Hydrophilic polyurethane foams medical consumer personal care cosmetics agricultural products Rynel     17183
Care Patient Care Product Manufacturer  17752
Bartlett Tree Experts Leader Residential Commercial Tree Care Services  17890
Safe Earth Lawn & Garden Care   17920
Carolina Outdoor Care Inc   17972
Glenwood Autism Behavioral Health us difference 17997
Mental Health North Central Alabama 18092
East Alabama Mental Health  18093
Jacksonville Mental Health  18094
Mental Health Assn-Madison Cty  18095
Baptist Health Ctr  18136
Mental Health Wellness Information Community Counseling Services    18150
Dayspring Behavioral Health 18162
Daysprings Behavioral Health    18164
Families Outpatient Mental Health Counseling Services   18167
Families Outpatient Mental Health Counseling Services   18168
Health Resources Of Arkansas    18170
Mental Health Council Of Ar 18172

如果我运行以下查询

SELECT TOP 3 * FROM TABLE_NAME where FREETEXT(content,'health care')

我得到前三行，而不是前三行，这三行更接近答案

如何获得前三个最相关的查询。

查询的速度是否与上一次一样快？

Answer 1

使用费特克特而不是FREETEXT。这将为您提供一组匹配结果，包括一个Rank，您可以订购by.Refer 这以获得更多的信息。

SELECT TOP 3 RANK, [KEY]
FROM FREETEXTTABLE(TABLE_NAME,content,'health care') 
ORDER BY RANK DESC

由KEY加入以从原始表中获取列。

SELECT TOP 3 TABLE_NAME.*
FROM FREETEXTTABLE(TABLE_NAME,content,'health care') as fullTextResults
join TABLE_NAME on fullTextResults.[KEY] = TABLE_NAME.Id
ORDER BY fullTextResults.RANK DESC