Jump to content

fulltext in boolean mode not working correcly


kalster

Recommended Posts

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.