4.17 Searching by Relevance

FULLTEXT indexes allow search results scored and sorted by relevance based on the semantic value of the search terms. As such, the most frequently used words are completely ignored and less frequently used words are assigned progresively higher values when scoring search results. When this functionality is turned on users are given the option to sort by date or relevance, with relevance being the default.

Before turning on this functionality be sure to create the two required FULLTEXT indexes in the database:

alter table stories add FULLTEXT storysearch_idx (title,introtext,bodytext)
alter table comments add FULLTEXT commentsearch_idx (subject,comment)


janra
2004-03-26