How to search through a database using phpmyadmin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • VodaHost
    General & Forum Administrator

    • Mar 2005
    • 12356

    How to search through a database using phpmyadmin




    This tutorial is about searching through a database using phpMyAdmin. We will assume that you are logged in to 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 of the phpMyAdmin setup 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, in a large white screen, is where the actions take place.

    Now let's learn how to use phpMyAdmin search. 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. This opens a phpMyAdmin 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 phpMyAdmin 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, etc.. If you had more than one table in mysql, you could limit the phpMyAdmin search to specific tables, by using the scrolling list. When you are ready, click Go to start the phpMyAdmin 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. This is the end of this tutorial. You now know how to use the Search feature in phpMyAdmin setup.

    How to rename database tables using phpmyadmin

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


Working...
X