Hi!
On Dec 20, Mark Maunder wrote:
> Sergei Golubchik wrote:
>
> I'm using version 4.
>
> I tried using 'IN BOOLEAN MODE' under version 4.0.0 but it doesn't recognize
> it. I'm using the MySQL 4.0.0-alpha Server (i386) (6.2M) binary RPM.
>
> Should I compile from source? I would like to but according to the website:
> "If the compiler reports version 2.96, then there is a problem (this is the
> case, for example on RH 7.x series or Mandrake 8.x). In this case, you should
> not try to compile your own binary before downgrading to one of the compilers
> mentioned above.".
> I'd rather not downgrade my compiler.
>
> The manual says "Since version 4.0.1 MySQL can also perform boolean fulltext
> searches using IN BOOLEAN MODE modifier." but 4.0.1 is nowhere to be found.
>
> I tried using the + operator (making all words required) hoping that it would
> put the database into boolean mode and it would disregard the 50% threshold,
> but I cant get it to return the score correctly with a query like:
> mysql> SELECT id, body, MATCH title,body AGAINST (
> -> '+test +phrase') AS score
> -> FROM articles WHERE MATCH (title,body) AGAINST
> -> ('+test +phrase');
>
> The scores returned are all equal to each other - and that of course does a
> logical AND which is not what I want. I just want it to be ordered by 'best
> match first' with a point score returned.
>
> kind regards,
> Mark.
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
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
