Here are some queries I did:
First one did not do what I wanted it to do... But no surprise, since I left
out the 'IN BOOLEAN MODE'
The second and third query did give me the wanted results, but not in the
way I want to construct these kinds of queries.
But is there a bug or something with the last query?... I was expecting it
to work. But whenever I give the query two words, each with a '+' infront, I
always get 0-hits.
I'm using MySQL Version 4.0.1-alpha
mysql> SELECT count(isbn) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('+windows +excel');
+-------------+
| count(isbn) |
+-------------+
| 3929 |
+-------------+
1 row in set (0.18 sec)
mysql> SELECT count(isbn) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('excel') and MATCH (tittel) AGAINST ('windows');
+-------------+
| count(isbn) |
+-------------+
| 174 |
+-------------+
1 row in set (0.16 sec)
mysql> SELECT count(isbn) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('excel' IN BOOLEAN MODE) and MATCH (tittel) AGAINST ('windows' IN BOOLEAN
MODE);
+-------------+
| count(isbn) |
+-------------+
| 174 |
+-------------+
1 row in set (0.04 sec)
mysql> SELECT count(isbn) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('+windows +excel' IN BOOLEAN MODE);
+-------------+
| count(isbn) |
+-------------+
| 0 |
+-------------+
1 row in set (0.12 sec)
---------------------------------------------------------------------
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
