Hi,
I have a table with consumer products. I have a row "product name" and
"brand".
If I do a full-text search in boolean mode for a term like "apple ipod" I get
results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms match "apple" and "ipod" they are returned with
the same score. Since "apple" also matches the "brand" for the product from
Apple, I'd like to give it a little boost when ranking the score so that it
is returned with a higher score. I think this would give me better search
results.
Right now both of these are returned with a score of 2, since they both have
2 matching words. If I could weight it, I would want:
Apple iPod (brand: Apple) (score=3)
TuneDock for Apple iPod (brand: Belkin) (score=2)
Is this possible?
Thanks,
Grant
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
