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.
asked Jan 21, 2010 at 03:37 AM in Default
Sekhar Misra 1
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?!?
answered Feb 04, 2010 at 07:07 AM