“What? MySQL Fulltext Search is not working!”
Well, this is what I thought before. I used to have MyISAM tables when developing an application. I never thought about table types.
I then realized that I was using InnoDB table type where MySQL Fulltext search is not working. So I had to alter the table from InnoDB to MyISAM.
ALTER TABLE table_name ENGINE = MyISAM;
-It is the name of your table.
And that solved my problem! :)
In case that you want to get it back to InnoDB, here’s the code:
ALTER TABLE table_name ENGINE = InnoDB;
If you have any inquiries/comments/questions/suggestions, just comment to this post. :)