kalpatron Posted July 25, 2008 Share Posted July 25, 2008 Hello to everybody I'm new to this forum and I spotted one little problem on my Full Text Search script. I have a database with video games and recently I just found that I cannot search the word "zero". Specifically I have an entry with the game "Resident Evil Zero" in my database and using for search term the word zero can't find anything. So to test this more, i entered the word "zero" in other tables and using the Full Text Search didn't return anything. Is there any problem with this word, or am I doing something wrong? Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/116547-full-text-search-problem-with-word-zero/ Share on other sites More sharing options...
waynew Posted July 25, 2008 Share Posted July 25, 2008 Show us the SQL? Quote Link to comment https://forums.phpfreaks.com/topic/116547-full-text-search-problem-with-word-zero/#findComment-599296 Share on other sites More sharing options...
JonnoTheDev Posted July 25, 2008 Share Posted July 25, 2008 zero is a MYSQL stop word meaning it will not be included in any search. See http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html However stop words can be modified in your mysql config Quote Link to comment https://forums.phpfreaks.com/topic/116547-full-text-search-problem-with-word-zero/#findComment-599453 Share on other sites More sharing options...
kalpatron Posted August 25, 2008 Author Share Posted August 25, 2008 Didn't have an internet connection for a month... Thanks for the answer! It'll solve my problem! Quote Link to comment https://forums.phpfreaks.com/topic/116547-full-text-search-problem-with-word-zero/#findComment-624809 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.