Sergei Golubchik wrote: > > > > Hmm, them 4.0.1 (with IN BOOLEAN MODE) won't help either :-( > > > It uses the same scoring scheme as the above query in 4.0.0 > > > > Where can I get 4.0.1? I dont see it on the website. > > Because it's not officially out yet :-) > (you can always use it before "official" release, fetching our > source tree - see the manual - but as far as I understand you'd > rather not to compile mysql yourself) > > We expect 4.0.1 to be out this week. > > > OK the scoring isn't that important. Will IN BOOLEAN MODE without using '+' or '-' > > operators give me a list ordered by best match first without the 50% threshold? > > Without 50% threshhold, yes. > Best match - hmm, it has very simple scoring, > for query "aaa bbb" (OR-type query), the row that contain two words is > always scored higher than the row with only one word. > There's no complex statistics involved.
That's exactly what I need. Thanks very much for all your help! --------------------------------------------------------------------- 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