OHH I remember my real question

[Anon]

Sorry for that last post. I thought of another problem. MySQL is great and love it to death. However I don't know how to do what I am thinking of. You live in Zipcode 90210. I have a table like zipcode1,zipcode2,zipcode3,zipcode4,zipcode5

Well I need it to look for Zipcode1 and see if anyone has 90210... and so on for all them.

I am thinking:
sql="Select * from blah where zipcode1='90210' or zipcode2='90210"; can that even happen? Is there some OR statement in MySQL query's? Or am I just retarted?

Thank you!
Chad

[Anon]

OR is a standard SQL command, as is AND.

SELECT *
FROM blah
WHERE zipcode1 = '90210'
OR zipcode2 = '90210';

Is a valid SQL query, it has nothing to do with MySQL other than MySQL has to support this syntax (which it does) for you to use it.

[Anon]

Thanks bud!
Chad