As stated earlier, multiple conditions may be combined using the OR operator. The following query shows a WHERE clause that selects rows having either a PERSON_GIVEN_NAME column beginning with Ste or a PERSON_ ADDRESS_CITY column equal to Los Angeles. SELECT PERSON_GIVEN_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_CITY FROM PERSON WHERE PERSON_GIVEN_NAME LIKE 'Ste%' OR PERSON_ADDRESS_CITY = 'Los Angeles';

The next query changes the OR operator from Example 4-7 to the AND operator. Note that only one row is returned now because both conditions must be true for a row to appear in the query results. SELECT PERSON_GIVEN_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_CITY FROM PERSON WHERE PERSON_GIVEN_NAME LIKE 'Ste%' AND PERSON_ADDRESS_CITY = 'Los Angeles';