Querying MySQL databases using phpMyAdmin
Query a MySQL databaseTo query a MySQL database:
- Log into your Hosting Dashboard.
- 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 Query option listed on the top section of the phpMyAdmin page.
- To build your query, specify your criteria using the fields below.
- Field: Select the table fields that you want to query. Tables and fields are displayed with the name of the table, a period, and then the name of the field.
- Sort: Select whether you want the results to be sorted in Descending order (top to bottom) or Ascending order (bottom to top).
- Show: Select this checkbox if you are selecting fields and want to have them displayed.
- Criteria: Enter your search criteria. For example, if you entered '3' without the double quotes, your query would basically read 'find all of the records where the field I selected is greater than 3'.
- And/Or: If you want to enter another search criteria, select whether you want the selected records to match both or either criterion then enter the string into the text box. You can select 'And' or 'Or' for two different search criteria within the same field and also when searching for more than one field at a time.
- Ins & Del Checkboxes: Select the Ins checkbox next to a criteria row or under a field column to add another option. Select the Del checkbox next to a criteria row or under a field column to remove an option.
- Add/Delete Criteria Row: Select the number of criteria rows to add (positive number) or delete (negative number). This option is similar to the Ins and Del checkboxes for the criteria rows, except that you are able to add or remove more than one option at a time.
- Add/Delete Field Columns Select the number of field columns to add (positive number) or delete (negative number)This is similar to the Ins and Del checkboxes for the field columns, except that you are able to add or remove more than one option at a time.
- Use Tables: Select the tables to query. Selected tables will affect the values in the Field field.
- Click Update Query so that your options will take effect as you make changes. The query will be written out in the SQL query on database field.
- Click Submit Query to run the query. The page displays the query code and results.
MySQL connections and query limits
A query limit is the maximum number of database actions performed in one hour by a specific user. Note that a user can have multiple concurrent MySQL connections, in which case the sum of all database actions for all connections cannot exceed the given limit.
- The maximum number of concurrent MySQL connections per user is 20.
- The maximum number of database queries per user is 75,000/hr. Note that you can upgrade to Wordpress Essential Plan to get a maximum database query of 150,000/hr.