MySQL Forums
Forum List  »  Full-Text Search

Full Text Search - Added In Boolean Mode Not Working
Posted by: D F
Date: March 13, 2006 06:39AM


In Lore (a knowledge base program) it had a full-text search. I added the "In Boolean Mode" statement but the searches don't work. It's on MySql Server 4.1.15. I can look at article with two words I want to search on and if I do +word1 +word2 it won't find anything.

Here's the statement:

"SELECT lore_articles.*, AS category_id, AS category_name, LEFT(content, $preview_length) AS preview, total_rating/num_ratings AS rating FROM lore_articles,lore_categories WHERE MATCH(title,content,keywords) AGAINST('$query' IN BOOLEAN MODE) AND AND lore_categories.published = 1 AND lore_articles.published = 1"

Is there something I'm missing or does it need to be changed?


Options: ReplyQuote

Written By
Full Text Search - Added In Boolean Mode Not Working
March 13, 2006 06:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.