MySql search help

[koolkrazy]

Hello friends

I am developing a small search for one site and i used the MATCH() and AGAINST() in my query and also added the index to the table as FULLTEXT and i got one result of relevance of the search.

Query was
SELECT tourid, MATCH(tourname) AGAINST ('italy and canada') as relevance FROM tours WHERE MATCH(tourname) AGAINST ('italy and canada')

Result
| 4 | 4.0752196555052 |
| 45 | 3.9875397180538 |
| 90 | 3.0998460661573 |
| 91 | 3.0649993007866 |
| 26 | 3.0309271945444 |
| 29 | 3.0309271945444 |
| 92 | 3.0309271945444 |
| 93 | 3.0309271945444 |

Now just like google i want to display a small gragh next to the search result. But i dont know on what scale is the relevance displayed? is it between 1-100? or 1-10?

Please help

[Weedpacket]

Originally posted by koolkrazy
But i dont know on what scale is the relevance displayed? is it between 1-100? or 1-10?

Well I don't really know; but if I wanted to find out and didn't want to spend time experimenting, the first place I'd look for the information would be the MySQL documentation.

[koolkrazy]

i did and didnt land in to any page which could provide me with that information!
Any suggestions?

[Weedpacket]

Originally posted by koolkrazy
i did and didnt land in to any page which could provide me with that information!
Any suggestions?

Experimentation; and try a MySQL forum - you're almost certainly not the first person to ask, and the people who're most likely to know the answers (short of the authors) are most likely to be on one of them!