Searching through a database with phpMyAdmin Print

  • 200

This article is all about searching through a database using phpMyAdmin. We will assume that you are signed in to phpMyAdmin. For the purpose of this article, we will use a database with one table for an example.

Let's begin by looking at the main screen of phpMyAdmin. The left hand panel is where you will find your database listed, and beneath the database will be any tables in that database. On the right hand side, in a large white screen, is where the actions are done.

Now let's learn a way to use Search. Begin by clicking on the the database you want to search in the left hand panel. This will display the information for the database in the right hand screen. At the top of that screen, click on the Search button. This presents a search window. In the blank, you need to tie the words or values you like to search for in the database. You could filter the search several ways. One option you can use is to choose a radio button that limits the search scope, such as all words, or the exact phrase, etc.. Should you had more than one table, you could limit the search to specific tables, by using the scrolling list. As soon as you are set, click Go to begin the search.

The following screen will show you incase there are any matches to your search, and if there are, where they are placed. You can now click on the Browse button at the end of the results, and it will show you the match. You certainly can at this moment make changes to that record if you like. This is the last part of this article. You already know how to use the Search function in phpMyAdmin.


Was this answer helpful?

« Back