knowj Posted December 3, 2008 Share Posted December 3, 2008 I have setup a fulltext search for one of our projects and its working great apart for one thing. If you type in fire and the index's contain `fires` it is unable to find these results. I am using a simple match/against/Boolean on an ANY search. Is this a restriction of FULLTEXT or am I just being retarded. It's not really relevant but I might as well include my query: SELECT *, MATCH(article_title, article_body) AGAINST ('$any' IN BOOLEAN MODE) AS score FROM `articles` WHERE MATCH(article_title, article_body) AGAINST ('$any' IN BOOLEAN MODE) I looked into Query Expansion but the results it started returning were completely irrelevant. [/code] Quote Link to comment Share on other sites More sharing options...
fenway Posted December 4, 2008 Share Posted December 4, 2008 Depends how common it is... read the refman page, fulltext is funny. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.