Fulltext Mysql Search

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

Leave a Reply

Your email address will not be published. Required fields are marked *