MySQL Fulltext

[rgraves]

I've been experimenting with the FULLTEXT option in MySQL to search a database and order the results based on relevance.

The relevance values I've got are between 0 and 1.3 approximately. What is the maximum value the relevance number can be?

What I'd like to do is have a graphical bar indicating how relevant the result is (i.e. 100%, 80%, 50%, etc).

Any ideas?

[rgraves]

Also, does anyone know if you can do a fulltext search across multiple tables?

For example, I have a table of problem reports that I want searchable as well as a table of solutions. Each problem can have multiple solutions hence I need both tables and want them both searchable at the same time via a fulltext search.

[rgraves]

I found the answer to my second question. You can't search multiple tables using FULLTEXT searching with MySQL 3.23.

Does anyone have an answer to my first question?

Rob