MySQL correct full-text relevance

[Anon]

I'm using the following SQL query to search four fields in two tables. All fields have full-text index.

"SELECT * FROM tblArticle, tblTextFile, tblInfoType WHERE (MATCH (Subline, Bottomline, SearchWords) AGAINST ('".$findString."') OR MATCH (Headline) AGAINST ('".$findString."')) AND tblArticle.fkTextFileID = tblTextFile.pkID AND tblTextFile.fkInfoTypeID = tblInfoType.pkID;"

The fields Subline, Bottomline and SearchWords are from the table tblArticle and the field Headline is in the table tblTextFile. All four fields are of the type Text but they only contain about three-four words each for every row. The query works but the problem is that hits where many of the words match the search string will be presented at the end of the result and hits with less accurate words will be presented early in the result. According to: http://www.mysql.com/doc/F/u/Fulltext_Search.html the hit with most relevance will be presented first. Can anybody help me?

[[deleted]]

You don't order anything, thus the order will be random, as they are found.

Try adding an ORDER BY clause using the MATCH outputs.