Learn cPanel

Controlling your Web Hosting Account has never been that easy thanks to cPanel web Control Panel!

• Last Updated: 04/28/2020
• ( 3 minutes reading )

How to search in Databases using phpMyAdmin?

Introduction

The ability to search is an amazing utility to have. phpMyAdmin is no stranger to it, and it fully supports it. Using this robust tool, you may look for strings or integers within your database. This can be very useful in certain situations. For example, when you have changed the domain of your website, and there are still entries in your database redirecting or loading content from the old domain name. PhpMyAdmin has a wide variety of functionalities that can efficiently help you find these records and replace them if needed. In this tutorial, we will take you through the process of searching your database using phpMyAdmin.

 

Accessing the phpMyAdmin tool

Before you can access the PHPMyAdmin functionality, you need to log into your cPanel account with us. To do so, please check our tutorial on How to access the cPanel service.

Once logged in, please navigate to the “Database” section and click on the “phpMyAdmin” icon. 

 

phpmyadmin-functionality

 

Clicking on the result redirects you to the “PHPMyAdmin” feature. In the left sidebar, you can see a list of all your databases.

 

Database List

 

Please select the database on which you want to perform the search.

 

Searching in Databases

After you have selected the database, please point your attention to the top side of the screen, where you can see the tab bar. There you can locate and access the “Search” tab.

 

Access Search Tab

 

After clicking on it, you are redirected to the "Search" page, which consists of a few sections. 

 

Search in database section

The first text field is intended for the string you are looking for. Therefore, please type it into it. 

 

Enter Database search string

 

You may also write numbers, regular expressions, or any entry which is inside your database.

 

Find section

Right beneath is the "Find" section, containing a few options you can choose. Let us go over them:

  • at least one of the words - If selected, this option matches any search containing at least one of the words you specified inside the text field.
  • all of the words - If selected, this option matches any results containing all of the words.
  • the exact phrase as a substring - If selected, this option matches any results related to the used phrase as a substring
  • the exact phrase as a whole field -  If selected, this option matches any results related to the used phrase as a whole field
  • as regular expression - If selected, this option matches any results matching a regular expression. This only works if a regular expression is used within the text field.

 

Select Find Option

 

Please select the desired option by clicking on the corresponding radio button.

 

Inside tables section

This section is located directly under the “Find” section. There is a content box inside, allowing you to select the database table within which you want to perform the search. Above the content box, there are two buttons - "Select all" and "Unselect all" allowing you to either select or unselect all the tables of your database, held in the content box. 

 

Select database table to search

 

If you want to choose an individual table, please click on it. You know that it is selected by the fact that it is highlighted.

Lastly, there is a text field below the content box where you can type in a specific column located inside the selected table above or the entire database.

When you have configured the search pattern, please click on the "Go" button located on the bottom right corner of the page.

 

Initiate Database search

 

This action presents a list of all the database tables you selected on the previous page. On the left side of this list, you can see the number of matches for every table.

 

That’s it! A handy method you can use to search for patterns inside your database using the phpMyAdmin tool! If you are experiencing issues with this functionality or you need assistance when using it, please feel free to contact our Technical Team. They are 24/7 available from your Client Area by submitting a ticket.

 

 

...
Nikola Zgurev
Technical Support Captain

Nikola is an accomplished tech-savvy extraordinaire with over six years of experience in the web hosting field. He started as a customer care representative and quickly rose the ranks to become a support supervisor and, eventually - the head of the technical department in HostArmada. His deep understanding of the client's needs, combined with his technical knowledge, makes him the perfect man to create the ideal harmony between client satisfaction and professional problem-solving. You will often find him creating helpful tutorials, articles, and blog posts that help existing customers get around.