Hello there, Another Fulltext question :) Yeah, I've been working a lot on this stuff now :)
I have a request to search companies in a huge database: SELECT CID FROM tblCompany WHERE MATCH (CompanyName) AGAINST ('Toyota Robert' IN BOOLEAN MODE) In boolean mode, my results are not sorted by relevance and then I want to order them by Company name. This gives the following : SELECT CID, CompanyName FROM tblCompany WHERE MATCH (CompanyName) AGAINST ('Toyota Robert' IN BOOLEAN MODE) ORDER BY CompanyName The problem is that this last query uses a filesort to give the results ordered the way I want to. And the question is : Is there a way to avoid this filesort, or a way to sort my results by relevance even in boolean mode. A way, or a trick ;) Thanks ! HMax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]