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.
Subject
Views
Written By
Posted
Full Text Search - Added In Boolean Mode Not Working
3907
March 13, 2006 06:39AM
2369
April 30, 2006 02: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.