How to Turn on MySQL Fulltext in cPanel
- 1). Log into your cPanel account.
- 2). Click "MySQL Databases."
- 3). Select the database you wish to search (if your site has more than one).
- 4). Type "MATCH (title, body)" into the search box. Omit quotation marks.
- 5). Replace "title" with a search term for within the table headers. For many full text searches, you might leave this blank. Be sure to leave the comma in.
- 6). Replace "body" with the full-text search term.
- 7). Click the "Search" button.
