This guide explains how to perform database searches in phpMyAdmin using cPanel.
STEP 1: Log in to cPanel.
There are two methods to log into your cPanel.
- Method 1: Log in to your cPanel directly.
- Method 2: Log in to your cPanel through your Customer Portal.
Through your Customer Portal;
- Log in to your Customer Portal.
- Click on "Log in to cPanel".
STEP 2: Locate the Databases section and click phpMyAdmin.
STEP 3: In phpMyAdmin, locate and click on the database you wish to search from the left-hand column.
STEP 4: Once inside the database, you’ll see a list of tables. Click on the Search tab at the top of the page.
STEP 5: Use the search box to enter the keywords you want to search for. Separate multiple keywords with commas.
STEP 6: Select how you want the search to be performed:
- At least one of the words
- All words
- The exact phrase
- As a regular expression
STEP 7: Choose the tables you want to search within. You can:
- Select all tables.
- Select specific tables by holding down the Ctrl key (or Cmd on Mac) while clicking on them.
STEP 8: Click the Go tab to execute the search.
STEP 9: Results will be displayed based on the selected tables. To explore further, click Browse next to a table to view matching records.
STEP 10: The matching records will be displayed. You can interact with them by copying, editing, or deleting them as needed.
