Google喜欢在SQL Server中使用全文搜索进行搜索查询

I am running a small website wherein I would like to make a functionality like Related Links section.

我正在运行一个小型网站,我想在其中制作相关链接部分等功能。

For that I created fulltext catalog and index.

为此,我创建了全文目录和索引。

So far I tried many ways to create search query which behaves like google, but I would say i was not even 10% close to what google is doing. During my research what i found was only following query was pulling good records.

到目前为止,我尝试了许多方法来创建搜索查询,其行为类似谷歌,但我会说我甚至没有接近谷歌正在做的10%。在我的研究期间,我发现只有以下查询才能提供良好的记录。

Select col1, col2
from MyTable
Where
FREETEXT(col1,  'User Passed Search Text')

Has anyone has good way to create a FullText Search Query which can help in getting better related records for given text?

有没有人有很好的方法来创建一个FullText搜索查询,它可以帮助获得给定文本更好的相关记录?

Thanks

3 个解决方案

#1

Seemsthe fulltext topic has been discussed quite a bit: Stackover Flow Pros and Cons of full text search types. I might suggest reading over that, as the query you're trying above doesn't even seem to be working that well.

看起来全文主题已经讨论了很多:Stackover Flow优点和缺点全文搜索类型。我可能会建议阅读,因为您在上面尝试的查询似乎甚至没有那么好用。

#2

Take a look at this article, you might find it useful

看一下这篇文章,你会发现它很有用

Full Text Search on SQL Server Central

SQL Server Central上的全文搜索

#3

in where condition put * in place of col1 it will search in complete table and gives you result check the link http://sqlmag.com/sql-server/sample-full-text-search-engine

在条件放置*代替col1它将在完整的表中搜索并给你结果检查链接http://sqlmag.com/sql-server/sample-full-text-search-engine

#1