How to Run Search in phpMyAdmin

This guide discusses how to run a search in phpMyAdmin using either cPanel or Plesk, helping you quickly locate data within your MySQL tables.

How to run a search in phpMyAdmin

1. Log in to your Customer Portal.
2. Go to Websites from the left navigation menu.
3. Click Settings next to the website you want to manage.

   

4. After clicking phpMyAdmin, you will be redirected to your phpMyAdmin home page.

   

   Alternatively, you can access phpMyAdmin using the following guides based on your hosting control panel:

   • cPanel
     How to Access phpMyAdmin from cPanel
      
   • Plesk
     How to Manage Databases With the Webadmin - Plesk
5. Locate the database you want to search by clicking on the database in the left column.

   

6. Once inside the database, a list of tables will be displayed. Click on the Search tab.

   

7. Using the search box, you can type the keywords you wish to search for. Each keyword is preferably separated by a comma. We will use "admin" as the keyword as an example.
8. Select which way you want to search:
   • At least one of the words.
   • All words.
   • The exact phrase.
   • As a regular expression.

     

9. Select which tables you want to search within. You can select them all, select some of them, or select just one. Hold down the Ctrl key on your keyboard while clicking to select more than one table.

   

10. Press the Go button.
11. It will now display the results based on the table.

    

12. Click on Browse next to one of the tables to view the results.

    

The records matching your search will be displayed on the screen, and you can interact with them in a variety of ways, such as copying, editing, or deleting.