MySQL Forums
Forum List  »  MyISAM

Re: Position-weighted full text ranking
Posted by: Rick James
Date: August 02, 2014 12:51PM

Just a thought...

SELECT
MATCH ... AGAINST (""bat foo sat bar mat baz" ...),
MATCH ... AGAINST (""bat foo sat bar mat" ...),
MATCH ... AGAINST (""bat foo sat bar" ...),
MATCH ... AGAINST (""bat foo sat" ...),
MATCH ... AGAINST (""bat foo" ...),
MATCH ... AGAINST (""bat" ...)
...

Then do something with the metrics you get.

Another thought... See if InnoDB does anything better.

Or maybe Sphinx.

Options: ReplyQuote


Subject
Views
Written By
Posted
2731
August 01, 2014 10:00AM
Re: Position-weighted full text ranking
1584
August 02, 2014 12:51PM


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.