How to sort the search result order by most relevancy?

Mojtaba_g79 · #1 (**permalink**) 01-18-10, 11:05

Dear friends.
I wanna know how can I optimize my search results?
Exactly when I try to use FULLTEXT search for more than one word, the result can be returned by any record that includes at least one of those words. I want to get the result ordered by most related records.
Is there any way in MySQL?

r937 · #2 (**permalink**) 01-18-10, 11:13

just repeat the MATCH expression in the ORDER BY clause

Code:

SELECT ...
  FROM ...
 WHERE MATCH ( ... ) AGAINST ( ... )
ORDER
    BY MATCH ( ... ) AGAINST ( ... ) DESC

Mojtaba_g79 · #3 (**permalink**) 01-19-10, 08:16

Many Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech