Adding MySQL FULLTEXT Support to WordPress
FULLTEXT support to WordPress is simple if you have access to phpMyAdmin. If not, it can still be done but is a little trickier if you’re not used to command-line. We’ll demonstrate how to modify your WordPress database using phpMyAdmin.
How To Modify Database
-
Start out by having a set of keywords to test against. You’ll need ‘before’ and ‘after’ test results. Also, I can’t stress this enough but back up your database before proceeding!
-
Next, log into your phpMyAdmin page and navigate to your {prefix}_posts table.
-
Click on the “Structure” tab.