Hi!
On Jan 09, Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC wrote:
>
> Hello
>
> Recently we have installed mysql ver 4.0.1(from
> binaries).We loaded about 1.6 million records in a table.
> One of the fields 'ti' is text field. We created fulltext
> index on this field.
>
> on giving following :-
> 1. select ti from p8387 where match ti against ('computer');
> 1701 rows were returned.
>
> 2. select ti from p8387 where match ti against
> ('processor');
> 5608 rows were returned.
>
> 3. select ti from p8387 where match ti against
> ('+computer +processor');
> it still returns 5608 rows.
>
> when we gave the following :
> 4. select ti from p8387 where match ti against
> ('computer') and match ti against ('processor')
> only 31 rows were returned
>
> Can anyone tell me what is the problem with statement no. 3
>
> does mysql 4.0.1 still not support this type of fulltext
> search.
>
> Pl. help
>
> Kind Regards
>
> P Tejpal
>
See the manual.
To use boolean operators in fulltext search you have to use
... AGAINST ("..." IN BOOLEAN MODE)
Yes, it's new to 4.0.1, but as boolean fulltext search in 4.0.0,
was not documented at all - it was kind of "hidden feature" -
we took the liberty of changing the syntax.
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
