JonathanAnon Posted March 24, 2006 Share Posted March 24, 2006 Hi I have a fulltext search that does not sort by the best score. I have read that this is the default but how do I sort it this way. I have added the ORDER by score part to the sql statement but it still does not work. It does not recognise the word score. Quote Link to comment https://forums.phpfreaks.com/topic/5648-fulltext-searching-by-score/ Share on other sites More sharing options...
wickning1 Posted March 24, 2006 Share Posted March 24, 2006 You don't use ORDER BY at all. It will automatically order results by relevance. MySQL's relevance algorithm may not meet your needs, but there's not much you can do about that. Quote Link to comment https://forums.phpfreaks.com/topic/5648-fulltext-searching-by-score/#findComment-20179 Share on other sites More sharing options...
JonathanAnon Posted March 24, 2006 Author Share Posted March 24, 2006 Hi and thanks for your response. Like I said I have seen queries on the net that ORDER BY score. I have also read that the MySQL does not automatically order by relevance itself. I'll look at it again. thanks, J Quote Link to comment https://forums.phpfreaks.com/topic/5648-fulltext-searching-by-score/#findComment-20248 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.