The Multi-Table Query Generator - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 204

Showing a Column
We check the Show checkbox so that we can see the column in the results.
Sometimes, we may just want to apply a criterion on a column and not include it in
the resulting page. Here, we add the phone column, ask for a sort on it, and choose
to show both the name and phone number. We also ask for a sort on the name in
ascending order. The sort will be done first by name, and then by phone number, if
the names are identical. This is because the name is in a column criterion to the left of
the phone column, and thus has a higher priority:
Updating the Query
At any point, we can click the Update Query button to see the progress of our
generated query. We surely have to click it at least once before executing the query.
For now, let's click it and see the query generated in the query area. In the following
examples, we will click Update Query after each modification: