FTS Sql Server 2008 question - assign weights to multiple columns

Question

I have a feeling this question might have been asked before, but I am not able to find it. So here it goes:

• I am searching through articles for words, phrases typed by users on a website
• my articles have different columns for title, keywords, body, summary.
• when I am searching I want the result to be more relevant if found in Title than Body for example

I know you cannot assign weights for columns (you can assign weights only to the words that are searched). I was thinking to fire 4 different queries for each column, and then UNION the results based on a simple rule. Do you think there might be a better solution?

Answer 1

I was able to find answers to similar question:

http://stackoverflow.com/questions/198152/how-do-i-assign-weights-to-different-columns-in-a-full-text-search

and

http://stackoverflow.com/questions/1710534/giving-precedence-weight-to-a-column-using-freetexttable