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]
