OR query problem (MySQL)

[Anon]

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")

Does MySQL Server support the OR command?

Can anyone help.

[Anon]

i have mysql 3.22.32 and OR is supported.

Try to enclose conditions in parenthesis:
SELECT * FROM product where (product_id = "1" OR product_id = "2");

[Anon]

no luck 🙁

I have version 3.23.33 so it should have worked.

When I try this

[pgudge]

no luck 🙁

I have version 3.23.33 so it should have worked.

When I try this:

SELECT * FROM product WHERE product_id = "1" OR bug_id = "2"

it only returns all product_id 1's with bug_id = 2. So it's as if it's working as a AND, I also tried the || but still no luck.

Federico wrote:

i have mysql 3.22.32 and OR is supported.

Try to enclose conditions in parenthesis:
SELECT * FROM product where (product_id = "1" OR product_id = "2");