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.