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] Link to comment https://forums.phpfreaks.com/topic/135331-fulltext-search-question/ 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. Link to comment https://forums.phpfreaks.com/topic/135331-fulltext-search-question/#findComment-706165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.