question

Sekhar Misra 1 avatar image
Sekhar Misra 1 asked

Full Text Search FreeTextTable Predicate Search Problem

Hello Everone,

I am using Full Text Search for our Search Algorithm.

Description: Say there is a table called as Table1 which contains following columns

Id, Name, Description

1, Car, Maruti Suzuki Car

2, Polycarbonate, Chemical used to compose polythene

3, Repair shop, Motor car repair shop

4, Mercedes Benz, Car

I have given full text index on Name and Description columns of Table1 From webpage I enter a keyword to search which should either be in Name or Description or both. I am using FREETEXTTABLE predicate for this.

For example say I searched for "Car" it will list down all the above results from Id 1 to 4 because it will search for the keyword "car" which is there in all the rows.

Howwever, "car" in "Polycarbonate" (Id=2) is not relevant to my search, hence I want only 3 records that is Id = 1,3,4. But I am unable to find any solution to avoid such situation using my current implementation.

Can you please help me out on this. This is very urgent requirement.

Thanks in advance.

Have a nice day.

sql-server-2008sql-server-2005full-text
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
RickD avatar image
RickD answered

Why not use CONTAINS or CONTAINSTABLE? These will give you everywhere there is car or similar, yet not give you polycarbonate..

I'm confused as to why you would use FREETEXTTABLE to search for something where you only want the full word?!?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.