MySQL Forums
Forum List  »  Full-Text Search

Fulltext score always integer
Posted by: Alex Gunshot
Date: September 25, 2006 06:42AM

Hello everybody,

I have a problem with fulltext search:

I have altered my table to use fulltext search, and the search basically works.
But: The scores I get are always integers (I've seen 0, 1 and 2 so far), while they are supposed to be floats.

My query is:
SELECT post_title,
MATCH(post_title, post_content)
AGAINST ('foo* bar' IN BOOLEAN MODE)
AS score
FROM posts
WHERE
MATCH(post_title, post_content)
AGAINST ('foo* bar');

My MySQL version is 5.0.24a.

Thanks for any hint.

Options: ReplyQuote


Subject
Views
Written By
Posted
Fulltext score always integer
6142
September 25, 2006 06:42AM
3003
September 25, 2006 08:28AM
2788
September 29, 2006 11:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.