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]
