1. Knowledge Base
  2. >
  3. MySQL Database Search in phpMyAdmin

MySQL Database Search in phpMyAdmin

This article discusses how to run searches through databases in phpMyAdmin with cPanel or Plesk.

The phpMyAdmin may look slightly different in the video below; however, the steps described should still be the same.

How To Run Search in phpMyAdmin

  1. Log in to your cPanel or Plesk.

  2. Navigate to your control panel and click the phpMyAdmin icon.

    Plesk:
    Plesk phpMyAdmin

    cPanel:
    cPanel phpMyAdmin

  3. Locate the database you want to search by clicking on the database in the left column.

    phpMyAdmin - Select Database

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

    phpMyAdmin - Search tab

  5. 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.
  6. Select which way you want to search:
    • At least one of the words.
    • All words.
    • The exact phrase.
    • As regular expression.

      phpMyAdmin - Search - Keyword Filter

  7. 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.

    phpMyAdmin - Search - Table Filters

  8. Press the Go button.
  9. It will now display the results based on the table.

    phpMyAdmin - Search Results

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

    phpMyAdmin - Browse 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.