You need to add the 'IN BOOLEAN MODE' modifier. Try:
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database
+tutorial' IN BOOLEAN MODE);
and
SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('+database -tutorial' IN BOOLEAN MODE);
--jeff
----- Original Message -----
From: "Lars Lautrup-Larsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 2:07 PM
Subject: Boolean operators doesnt work in fulltext searched (4.0.1)
> Description:
> According to the manual, new boolean operators should be available in
MySQL
> v. 4.0.
> I have found that the + and - operator does not work at all, as the
> testcase below shows.
> I have used the fulltext search example from the manual as the testcase:
>
> How-To-Repeat:
>
> CREATE TABLE articles (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY
KEY,
> title VARCHAR(200),body TEXT, FULLTEXT (title,body));
>
> INSERT INTO articles VALUES
> (0,'MySQL Tutorial', 'DBMS stands for DataBase Management ...'),
> (0,'How To Use MySQL Efficiently', 'After you went through a ...'),
> (0,'Optimising MySQL','In this tutorial we will show how to ...'),
> (0,'1001 MySQL Trick','1. Never run mysqld as root. 2. Normalise ...'),
> (0,'MySQL vs. YourSQL', 'In the following database comparison we ...'),
> (0,'MySQL Security', 'When configured properly, MySQL could be ...');
>
> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database
> tutorial');
> #Returns 3 rows as expected.
>
> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database
> +tutorial');
> #Returns 3 rows - should return 1 row.
> #The words "database" and "tutorial" both exists in the first row only.
>
> SELECT * FROM articles WHERE MATCH (title,body) AGAINST
> ('+database -tutorial');
> #Returns 3 rows - should return 2 rows.
>
>
> Fix:
> None.
>
> Synopsis: Boolean operators doesnt work.
> Submitter-Id: ?
> Originator: Lars Lautrup
> Organization: 3L-Data
> MySQL support: none
> Severity: Non-critical
> Priority: medium
> Category: mysqld
> Class: sw-bug
> Release: mysql-4.0.1
>
> Exectutable: mysqld-nt
> Environment: AMD Thunderbird 1Ghz - 512MB RAM
> System: Win2000 Server
> Compiler: None used.
> Architecture: i
>
>
> Regards,
>
> Lars Lautrup.
>
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
