<div>
Ok. So you are saying that there is no max value for the rank/relevance?
</div>


Ok. So you are saying that there is no max value for the rank/relevance?

<div>
correct. the more words in the collection correspond to a word in the row, the higher the value. the less words in the row, the higher the value...
</div>


correct. the more words in the collection correspond to a word in the row, the higher the value. the less words in the row, the higher the value...

<div>
I guess then I will just calculate a relevancy percentage for each record using the maximum value in the index. Thanks for your help.
</div>


I guess then I will just calculate a relevancy percentage for each record using the maximum value in the index. Thanks for your help.

<div>
<div class="content wysiwyg-content">
I have a select statement that returns the rank of a search term.<br />
<br />
select ititle, ifullurl, idesc, icontent, MATCH (ititle, icontent) AGAINST ('industrial automation') as rank from ff_index where (MATCH (ititle, icontent) AGAINST('industrial') AND MATCH (ititle, icontent) AGAINST('automation')) order by rank desc LIMIT 0, 20<br />
<br />
Can someone tell me what the range is for the rank? I have seen it get above 6 so I would assume that it is from 0 to 10. Can someone verify that for me? Thanks.
</div>
</div>


I have a select statement that returns the rank of a search term.

select ititle, ifullurl, idesc, icontent, MATCH (ititle, icontent) AGAINST ('industrial automation') as rank from ff_index where (MATCH (ititle, icontent) AGAINST('industrial') AND MATCH (ititle, icontent) AGAINST('automation')) order by rank desc LIMIT 0, 20

Can someone tell me what the range is for the rank? I have seen it get above 6 so I would assume that it is from 0 to 10. Can someone verify that for me? Thanks.

Rank range for Match Against

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.