Databases Reference
In-Depth Information
By examining the positioning of the
AND
and
OR
operators, we can see that the first
conditions are linked by an
AND
(because
AND
is chosen under the
author_name
column) and that the second row of conditions is linked to the rest by the
OR
operator. The condition we just added (
LIKE
'%8%'
) is not meant to find anyone,
since in an exercise in Chapter 12, we changed the phone number of all authors with
name 'Smith' to '444-5555'.
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
):
Search WWH ::
Custom Search