[SOLVED] Fulltext indexing and MATCH()..AGAINST()

[morphboy23]

I've been checking a lot of examples for utilizing fulltext indexing and how to use MATCH()...AGAINST(), and I noticed that all the relevancy scores returned in these examples are not integers, many times below 1 even. Yet my queries always return whole-number scores, like 1 2 3 etc. Nothing like the .8943246 (whatever) I've seen elsewhere. Am I doing something wrong?

[Wildbug]

You may be somehow (inadvertently) casting the value as an integer or looking at the wrong value.

[morphboy23]

Here is an example of one of my queries:

 

SELECT DISTINCT u.iduser, u.username, i.idinquiry, i.title, i.categories, i.date, i.anonymous, 
     (SELECT COUNT(*) FROM responses AS r WHERE r.idinquiry = i.idinquiry) AS counter, 
     MATCH(i.title, i.text) AGAINST('" . $q . "' IN BOOLEAN MODE) AS score 
   FROM users AS u, inquiries AS i 
   WHERE MATCH(i.title, i.text) AGAINST('" . $q . "' IN BOOLEAN MODE) AND u.iduser = i.iduser ORDER BY score DESC

 

Anyone have any ideas? I'm not sure why the score would be converted to integers, if that is even the case. Any help is appreciated.

[Wildbug]

How many rows are in the database?

[morphboy23]

In the database? Not sure... The 'inquiries' table has about 30-40 test rows with the fulltext index (title, text)

[Wildbug]

Yeah, the table.

 

I don't think there's any problem.  It's the boolean mode that is giving you the integers.  Try removing that and see the floats.