help with search query, should be quick :)

[Dolemite50]

Hi,
I am building a site that allows users to insert coming events. They will enter a zip code and a city, which will be stored in 2 seperate fields in mysql.
If a member comes to the site, I want them to be able to search for events by city or zip. I want to just use one search field that says "Enter city or zip code" and have it search the mysql table for either column.
Something like
SELECT * FROM events where city_field or zip_code_field is like '$input';

but I cant quite get a right.

THanks for any help.

[chyan]

maybe this could help

select from events where city='$input' union select from events where
zip code field = '$input'