MobileRead Forums - View Single Post

Alexander Turcic · 08-19-2007, 06:14 AM

Our search feature relies on the underlying fulltext search engine of our database. For performance reasons, this engine uses a list of "stopwords" that it happily ignores during searches. You find the list here: http://dev.mysql.com/doc/refman/5.0/...stopwords.html
Boolean search is supported. When doing boolean searches make sure it is sorted by relevancy in a descending order. The default is by date in descending order.
Whole sentences may give a poor results due to MySQL's fulltext algorithm.
Search keywords must contain at least three characters unless they are part of a quote (a literal string).

KlondikeGeoff, in your particular case, searching for "A Tale of Two Cities" (including the quotes) would search for the exact phrase. Without the quotes, the search would reveal all posts that contain all of the keywords. Since two keywords are less than three characters, A and of, your search is aborted. I could, if desired, apply some changes to our search algorithm to not abort the search but simply ignore those two keywords and to continue the search with the remaining two.

Nat mentioned the search "The House" Borderland. This would search for the literal string "The House" with the boolean AND Borderland.

08-19-2007, 06:14 AM	#16
Alexander Turcic Fully Converged Posts: 18,175 Karma: 14021202 Join Date: Oct 2002 Location: Switzerland Device: Too many to count here.	Our search feature relies on the underlying fulltext search engine of our database. For performance reasons, this engine uses a list of "stopwords" that it happily ignores during searches. You find the list here: http://dev.mysql.com/doc/refman/5.0/...stopwords.html Boolean search is supported. When doing boolean searches make sure it is sorted by relevancy in a descending order. The default is by date in descending order. Whole sentences may give a poor results due to MySQL's fulltext algorithm. Search keywords must contain at least three characters unless they are part of a quote (a literal string). KlondikeGeoff, in your particular case, searching for "A Tale of Two Cities" (including the quotes) would search for the exact phrase. Without the quotes, the search would reveal all posts that contain all of the keywords. Since two keywords are less than three characters, A and of, your search is aborted. I could, if desired, apply some changes to our search algorithm to not abort the search but simply ignore those two keywords and to continue the search with the remaining two. Nat mentioned the search "The House" Borderland. This would search for the literal string "The House" with the boolean AND Borderland.