The Add search conditions box will be explained in the Applying a WHERE
Clause section later in this chapter.
Ordering the Results
The Display order dialog permits to specify 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 available.
It should be noted that on the results page, we can change the sort order using the
techniques explained in Chapter 4, First Steps.
Searching Data
[ 154 ]
Search Criteria by Field: Query by Example
The main usage of the Search panel is to enter criteria for some fields so as to retrieve
only the data in which we are interested. This is called Query by example because
we give an example of what we are looking for. Our first retrieval will concern
finding the book with ISBN 1-234567-89-0. We simply enter this value in the isbn box
and choose the = operator:
Clicking on Go gives the results shown in the following screenshot. The four fields
displayed are those selected in the Select fields dialog:
This is a standard results page. If the results ran in pages, we could navigate through
them, and edit and delete data for the subset we chose during the process. Another
feature of phpMyAdmin is that the fields used as the criteria are highlighted by
changing the border color of the columns to better reflect their importance on the
results page.
Pages:
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157