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. 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? 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 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! 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
Archived
This topic is now archived and is closed to further replies.