Searching Data - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 152

Search options
The Options slider reveals additional panels to further refine the search process.
Selecting the fields to be displayed
In the Options slider, a Select fields panel facilitates selection of the fields to be
displayed in the results. All fields are selected by default, but we can control-click
other fields to make the necessary selections. Mac users would use command-click to
select/unselect the fields.
Here are the fields of interest in this example:
We can also specify the number of rows per page in the textbox next to the field
selection. The Add search conditions box will be explained in the Applying a WHERE
clause section, which will follow shortly.
Ordering the results
The Display order dialog permits the specification of an initial sorting order for the
results to come. In this dialog, a drop-down menu contains all the table's columns;
it's up to us to select the one on which we want to sort. By default, the sorting will be
in Ascending order, but a choice of Descending order is also available.
It should be noted that on the results page, we can change the sort order using the
techniques explained in Chapter 4.
Applying a WHERE clause
Sometimes, we may want to enter a search condition that is not offered in the
Function list of the query by example section. The list cannot contain every possible
variation in the language. Let's say we want to ind all the English or French topics
using the IN clause. To do this, we can use the Add search conditions section.