MySQL Forums
Forum List  »  Full-Text Search

Truncation operator and relevance ranking?
Posted by: David Robertson
Date: May 05, 2005 01:12PM


We would like to begin supporting the truncation operator on our website's search engine--however, we still require the results to be sorted by relevance. If a client enters "televis*" into the search engine, and we perform the search in boolean mode, pages containing "television", "televise", "televised", etc will be returned. However, because it is a boolean mode search, all rows will have a relevancy value of 1.

A user-provided "workaround" on the MySQL site said to use the same keywords but NOT in boolean mode to get a usable relevance ranking. However, a standard fulltext search for "televis" or "televis*" will return no rows.

Anyone have any experience with a similar problem, and could provide some insight into getting a trustworthy relevance ranking?

Thanks in advance.

Edited 1 time(s). Last edit at 05/05/2005 01:12PM by David Robertson.

Options: ReplyQuote

Written By
Truncation operator and relevance ranking?
May 05, 2005 01:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.