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

Hello,

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.*, lore_categories.id AS category_id, lore_categories.name 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 lore_articles.category_id=lore_categories.id AND lore_categories.published = 1 AND lore_articles.published = 1"

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

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text Search - Added In Boolean Mode Not Working
3907
D F
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.