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.

more ▼

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

avatar image

Sekhar Misra 1
1 1 1 1

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

1 answer: sort voted first

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?!?

more ▼

answered Feb 04, 2010 at 07:07 AM

avatar image

1.7k 2 3 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

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

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Jan 21, 2010 at 03:37 AM

Seen: 2317 times

Last Updated: Jan 21, 2010 at 03:37 AM

Copyright 2018 Redgate Software. Privacy Policy