How to Turn on MySQL Fulltext in cPanel
In its default installation, cPanel comes with the MySQL database program. This organizes back-end site data into tables, allowing for efficient processing and loading for users. You can search MySQL from within cPanel, but a search only looks at the table headers by default. To turn on a full text search, you need a special keyword. This search could take several minutes, depending on the size or your database(s).
Other People Are Reading
Instructions
-
-
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.
-
1
