We need someone to advise on how to get the ordering correct for our full text search.
when we search for “Red Car” the results come back with everything that has the word “red” and “car”
results are muddled and need to be cleaned up.
We need results to come back in the following order as:
“Red Car” [exact match]
“red + car” [relevancy – so if 1 article has red + car in the description, it will bring this back]
“red” [bring back “red”]
“car” [bring back “car”]
please advise. We are using
Apache version 2.2.17
PHP version 5.2.17
MySQL version 5.0.91-community-log