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! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Try Yahoo! Personals
