Jump to content


Photo

Fulltext searching by score?


  • Please log in to reply
2 replies to this topic

#1 JonathanAnon

JonathanAnon
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 24 March 2006 - 12:33 AM


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.

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 24 March 2006 - 03:30 AM

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.

#3 JonathanAnon

JonathanAnon
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 24 March 2006 - 12:31 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users