Compare multiple values using SELECT

[Anon]

Hi,

I am relatively new to the PHP/MySQL environment so I'd appreciate any help.
I need to do a SELECT on a MySQL database that has an 'AND' as well as multiple 'OR's.

An example would be:
SELECT name, city FROM employee WHERE name='Fred' AND city='New York' OR city='London'

How can I format this statement to return the desired rows?

Thanks,
Damien

[mikesgt2]

SELECT name, city FROM employee WHERE (name='Fred' AND city='New York') OR city='London'

[interactive]

hey i think they taught us that in algerbra class so it wasn't all a waste of time afterwards...