mysql full text bug/problem ?

[cristian ditoiu]

Hi .
One table with three filed full-text indexed :
titlu,continut,descriere
qry :
SELECT autori.nume as autor,
ref_data.id as id_ref,
ref_data.marime as marime,
ref_data.clasa as clasa_ref,
ref_data.titlu,
ref_data.nota as nota
,materii.*,MATCH (titlu,continut,descriere) AGAINST ('conceptia') as muian
FROM
materii,ref_data,referat_categ,autori
WHERE
referat_categ.categ_id=materii.id AND
ref_data.id=referat_categ.ref_id AND
ref_data.autor_id=autori.id
order by muian desc LIMIT 0, 30

The results are very disapointing :

Conceptia politica a lui Nae I
gives             relevance 7.10530698297792
Conceptia si conceptia are loc atunci cand doua celule fuzioneaza 1
gives             relevance 1.83638876238596

imho the second result should give higher relevance on keyrowd 'conceptia' .

using
mysql  Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386)


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php