kalster Posted October 18, 2014 Share Posted October 18, 2014 fulltext in boolean mode is not matching ignored words in mysql. ENGINE is set for myisam. mysql collation is utf8_general_ci. i have altered table using... ALTER TABLE users ADD FULLTEXT(userName); when i view mysql indexes, userName is username instead. I am not sure if this matter as there is not an error message when searching. SELECT * FROM users WHERE MATCH (userName) AGAINST ('$keywords' IN BOOLEAN MODE) I have restarted mysql and still does not match some 5 character words. in the mysql config, word length is set to 4. have i missed something? Link to comment https://forums.phpfreaks.com/topic/291917-fulltext-in-boolean-mode-not-working-correcly/ Share on other sites More sharing options...
Barand Posted October 18, 2014 Share Posted October 18, 2014 Are the words you can't find in this list http://dev.mysql.com/doc/refman/5.5/en/fulltext-stopwords.html Link to comment https://forums.phpfreaks.com/topic/291917-fulltext-in-boolean-mode-not-working-correcly/#findComment-1494130 Share on other sites More sharing options...
kalster Posted October 18, 2014 Author Share Posted October 18, 2014 yes Link to comment https://forums.phpfreaks.com/topic/291917-fulltext-in-boolean-mode-not-working-correcly/#findComment-1494133 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.