OR query problem (MySQL)

[admin]

I\'m trying to get some result from a table where either two columns contain the strings given.

i.e.

SELECT * FROM product where product_id = \"1\" OR product_id = \"2\"

I have tried so many different ways but all I get back is the first WHERE statement, (all product_id = \"1\")

I have also tried:

SELECT * FROM product where (product_id = \"1\" OR product_id = \"2\")

but again no luck,

Please Help.