The Multi-Table Query Generator - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 208

To demonstrate that the OR operator links both the criteria rows better, let's now add
a condition, LIKE '%8%' , on the phone number.
By examining the positioning of the AND and OR operators, we can see that the first
row of the conditions is linked by the AND (because AND is chosen under the name
column) operator, and the second row of conditions is linked to the rest by the OR
operator. The condition we've just added ( LIKE '%8%' ) is not meant to find anyone,
since, we changed the phone number of all the authors with the name "Smith" to
"444-5555" (in Chapter 12).
If we want another criterion on the same column, we just add a criteria row.
Adjusting the number of criteria rows
The number of criteria rows can be changed in two ways. First, we can select the Ins
checkbox under Criteria to add one criteria row (after clicking on Update Query ).
As this checkbox can add only one criteria row at a time, we'll uncheck it and use the
Add/Delete Criteria Row dialog instead. In this dialog, we choose to add two rows.