This posts neglects to mention a few key points about the FULLTEXT search....
1. You have to use MyISAM tables which dosen't support transactions like InnoDB tables do.
2. You need to make sure you adjust the FT MAX LENGTH parameter which I believe is 4 by default meaning you can search on 3 letter words like say "USB" for example
1. You have to use MyISAM tables which dosen't support transactions like InnoDB tables do.
2. You need to make sure you adjust the FT MAX LENGTH parameter which I believe is 4 by default meaning you can search on 3 letter words like say "USB" for example