[RESOLVED] Is there an (OR) operator for mySQL queries?

[contrasites]

I've used one before but can't remember what it was, say for example I need to SELECT 2 different specific values from the same field.

...something like:

$query = "SELECT * FROM table1 WHERE field1 = 'dog' OR field1 = 'cat' LIMIT 0,100";

...of course the above statement will return an error but you get the idea of what I am trying to do.

I haven't been able to figure it out yet.

Thanks for any help. 😉

[NogDog]

Well, OR is the correct logical or operator, so if that query is failing it's probably due to something else.

[contrasites]

wow, I guessed I solved my own problem then because that worked!

thanks!🙂