Jump to content

Archived

This topic is now archived and is closed to further replies.

JonathanAnon

Fulltext searching by score?

Recommended Posts


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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.