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