Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  How-Tos  >  How to search MySQL tables in phpMyAdmin?
Top Scroll

How to search MySQL tables in phpMyAdmin?

 2 min

To search MySQL tables in the database follow these steps :

1. Log into the Manage MySQL tool.

2. In your current MySQL Databases section, click on login name for a database to log into phpMyAdmin.

3. On the phpMyAdmin program window at the left side, click on the database in which the table resides.

4. Click on the table that will display the Structure page of the table.

5. Click on Search.

6. Build a query or query by example :

To Build a query :

(i) In the Select fields (at least one) section, select the fields that you want to get displayed in the final results. The list contains all the fields present in the table.

(ii) In the Display XX records page section, enter a number at which you want to limit the number of records displayed. By default, it is 30.

(iii) In the section for Display order, select a field and then assign Ascending or Descending order, depending on the sequence you want to sort the result.

(iv) In the section for Add search conditions, enter any specific conditions for the search.

Example : field_name < 1, field_name = (2+1)*3

Query by example :

In the section for Do a ‘query by example’ (wildcard: ‘%’), you can search for specific words or values in fields, by entering the search criteria into the appropriate fields.

By entering data into the field will bring up the result in the exact field. Or to broaden a search you can add a Wildcard symbol before or after the word you are searching for.

7. Click on Go to run the query and to display the code and results.

Also Read :

1)How to import MySQL tables using phpMyAdmin?

2) Learn To Repair And Optimize MySQL Database using phpMyAdmin

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.