Searching MySQL tables in phpMyAdmin
To search MySQL tables in phpMyAdmin:
- Log in to your account Hosting Summary.
- On the left pane, click on MySQL Management.
- In the MySQL Management section, select the Database Name where you want to do the query, then hit Manage.
- Choose the Database User and click phpMyAdmin.
- On the left pane of your phpMyAdmin page, click on the Database User.
- Click on the table to display the Structure page for the table.
- Click Search.
- Build a query or query by example:
Build a query Query by example
In the Do a 'query by example' (wildcard: '%') section, you can search for specific words or values in fields by entering the search criteria into the appropriate fields.
Entering data into a field will only bring up results with the exact data in the exact field. To broaden the search, you can add a wildcard symbol before and/or after the word you are searching for.
- In the Select fields (at least one) field, select the fields you want to be displayed in the final results. The list includes all of the fields in the table.
- In the Display XX records per page field, enter a number if you want to limit the number of records displayed. The default is 30.
- In the Display order field, select a field and then indicate Ascending or Descending order if you want to sort the results.
- In the Add search conditions field, enter any specific conditions for the search.
For more information, click the documentation icon to the right of the field name to go to the Functions and Operators chapter of the MySQL Manual.
- Click Go to run the query and display the code and results.