> Hi
>
> I must be missing something obvious. I'd like to write a query that
> ranks the row containing the most unique keywords first, rather than
> the row with the most keywords.
>
> 1) my user enters "red green blue"
> 2) my query include somthing like freetexttable (xxx,xxx, 'red green
> blue' )
> I would like the top-ranked result to be
>
> ".. ... red.. green .. .. blue... .. "
>
> not
>
> "red red red green purple orange red"
>
> Currently the density of the "red" keyword in the second row is giving
> it top rank. This isn't right. What am I missing? Is there a way to
> limit the impact of high keyword occurrency or change the ranking
> method?
>
> Thanks.
>