Knowledgebase

Searching through a database with phpMyAdmin

This tutorial is about searching through a database using phpMyAdmin. We will assume that you are logged into phpMyAdmin. For the purpose of this tutorial, we will use a database with one table for an example.

Let's start by looking at the main screen of phpMyAdmin. The left hand panel is where you will find your database listed and below the database will be any tables in that database. On the right hand side is a large white window and this is where the activity takes place.

Start by clicking the on the database you wish to search in the left hand panel. This will bring up the details for the database in the right hand screen. At the top of that screen, click on the search button to open the search window. In the blank you need to enter the words or values you want to search for in the database. You can refine the search several ways.

One method you can use is to select a radio button that limits the search scope, such as all words or the exact phrase. If you had more than one table you could limit the search to specific tables by using the scrolling list. When you are ready, click go to start the search.

The next screen will show you if there are any matches to your search and if there are, where they are located. You can now click on the browse button at the end of the results and it will show you the match. You can now make changes to that record if you wish.

For additional assistance, contact us by submitting a support ticket.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Quick Navigation
Language:

Client Login:

Email

Password

Remember Me