Running SQL queries on a database with phpMyAdmin

phpMyAdmin lets you run SQL queries directly against your database tables, giving you full control over your data beyond what the point-and-click interface offers.

Opening the SQL query window

There are two ways to reach the SQL query window in phpMyAdmin.

From the database view:

1. Log in to cPanel and open phpMyAdmin.
2. In the left-hand panel, click the database you want to work with.
3. Click the SQL tab at the top of the main panel.

From the table view:

1. In the left-hand panel, click the specific table you want to query.
2. Click the SQL tab. phpMyAdmin pre-fills a basic SELECT statement for that table, which you can edit or replace.

Running a query

1. Type your SQL command into the query box. For example, to find every customer in London:

SELECT * FROM customers WHERE city = 'London';

2. Click Go to run it. phpMyAdmin shows the matching rows below, along with how many were returned.

Learning SQL syntax

For a full reference on SQL syntax, see the MySQL documentation.