I would like to propose a change to the Forum Search Function. By adding an additional snippet of MySQL code: "IN BOOLEAN MODE". This would certainly enhance the ways we can search through the forum, especially + and - functionality plus allowing a search by phrase in double quotes.
I ran several tests locally, inserting the new code in the SearchResults() function in the ForumHolder.php file:
. . . return DataObject::get("Post", "MATCH (Title, Content) AGAINST ('$SQL_query' IN BOOLEAN MODE) $SQL_authorClause", "MATCH (Title, Content) AGAINST ('$SQL_query') DESC", "", (int)$_GET['start'] . ', 10'); . . .
I would love to get some feedback, particularly from anyone with a larger data set to work with.