On 29 Apr 2002, at 21:45, Mouratidis wrote: > Problem is, relevance can be anything. It could be 3.6 for example, and > multiplying that with a 100 will give me a number > 100. The way I had done > it was to divide all results with the highest value of relevance and get > something that was a percentage. But, if you do that, then if you have for > example a search for the term: > > 'Another' > > and the best match is 'Another book about Perl', then this match is > displayed as 100%. Which obviously, doesn't look right as it is considerably > off the real relevance.
What is "the real relevance"? I don't see why that "obviously" doesn't look right. I think that's the root of your problem. You have some concept of relevance as a percentage based on something, but none of us know what the basis is, so it's hard to help you. Once you've thought through what your definition of relevance is, then calculating it shouldn't be hard. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
