I am using the freetext function in SQL server to search through a description field of products. I realize that the catalog contains an index of words for the field and only references the record it belongs to.
The problem is the order in which the result set comes back. The field contains, for instance, several semi custom items (semi-custom vertical flags, semi-custom 5'x3' flags, semi-custom A-Frame signs) It seems that even if you submit the string "semi custom flags" the results come back with all A-Frame signs first then the flags which may not even be the particular type your searching for. I have this sorted by rank descending but this is still way off.
Is there anyone who can explain how this function ranks the results and any ideas of how I can fix this?
Thanks in advance,
J
The problem is the order in which the result set comes back. The field contains, for instance, several semi custom items (semi-custom vertical flags, semi-custom 5'x3' flags, semi-custom A-Frame signs) It seems that even if you submit the string "semi custom flags" the results come back with all A-Frame signs first then the flags which may not even be the particular type your searching for. I have this sorted by rank descending but this is still way off.
Is there anyone who can explain how this function ranks the results and any ideas of how I can fix this?
Thanks in advance,
J