Google like search query using Full Text Search in SQL Server

sql-server search full-text-search freetext
dotnetguts picture dotnetguts · Jul 9, 2010 · Viewed 10.2k times · Source

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.

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?

Thanks

Answer

Petrogad picture Petrogad · Jul 9, 2010

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.

Related questions

How do I search an SQL Server database for a string?

I know it's possible, but I don't know how. I need to search an SQL Server database for all mentions of a specific string. For example: I would like to search all tables, views, functions, stored procedures, ... for string "tblEmployes" (…

Read More
Find index of last occurrence of a sub-string using T-SQL

Is there a straightforward way of finding the index of the last occurrence of a string using SQL? I am using SQL Server 2000 right now. I basically need the functionality that the .NET System.String.LastIndexOf method provides. A little …

Read More
Find a string by searching all tables in SQL Server Management Studio 2008

Is there any way to search for a string in all tables of a database in SQL Server Management Studio 2008? I want to search for string say john. The result should show the tables and their respective row that contain …

Read More