x

Full Text Search FreeTextTable Predicate 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

Pls. Note: Columns of Table1 are given in veritical fashion to have a better visiblity in the question.

(Column 1) Id: 1,2,3,4 (Column 2) Name: Car,Polycarbonate,Repair shop,Mercedes Benz
(Column 3) Desc: Maruti Suzuki Car,Chemical used to compose polythene,Motor car repair shop,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.

more ▼

asked Jan 21, 2010 at 03:13 AM in Default

Sekhar Misra gravatar image

Sekhar Misra
22 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1948
x1840
x46

asked: Jan 21, 2010 at 03:13 AM

Seen: 1780 times

Last Updated: Jan 04, 2013 at 11:22 PM