Re: Problem with FULLTEXT searches

2003-06-27 Thread Cliff
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 &g

Problem with FULLTEXT searches

2003-06-27 Thread Cliff
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.i