Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter
of optimizing it now. Thanks.
----- Original Message -----
From: "Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 8:13 AM
Subject: Problem with FULLTEXT searches
> I am trying to get the fulltext search working properly as described in
the
> manual but some queries do not seem to be working correctly. When I run
this
> query:
>
> SELECT allusa.name,title,full_text,match(title,full_text) against
('chicken
> soup lemon') from recipes, bb.allusa where innid = bb.allusa.id AND
> match(title,full_text) against ('chicken soup lemon') LIMIT 0, 10
>
> It displays the results fine. Then I try this:
>
> SELECT allusa.name,title,full_text,match(title,full_text) against ('
> +chicken +soup +lemon ') from recipes, bb.allusa where innid =
bb.allusa.id
> AND match(title,full_text) against (' +chicken +soup +lemon ') LIMIT 0, 10
>
> The result returned are the same as the query above...I thought the +
clause
> made the search do a boolean AND search, but it does not seem to be making
> any difference. Is there a bug in the fulltext search? I have tried
> different queries as well with the same results. I am running mysql 4.0.12
> on freebsd 4.8. Thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
