[MySql] Help for a query

[__ndr____no___]

I have this query wrong:

query="SELECT * FROM tabella WHERE id=3 AND id=4"

how I can correct it?

😕

[ultraslacker]

WHERE id=3 AND id=4 is your problem, which is like saying WHERE 3=3 AND 3=4.

Do you mean WHERE id=3 OR id=4?

[__ndr____no___]

Originally posted by ultraslacker
WHERE id=3 AND id=4 is your problem, which is like saying WHERE 3=3 AND 3=4.

Yeah.. I know...
I have the necessity to make this:

select all data with id=3 and select all data with id=4

with one single query...

😕 🙁

[__ndr____no___]

query = " SELECT FROM tabella WHERE id IN ('A', '') ";

Simple, not? 😃

[ultraslacker]

query = " SELECT FROM tabella WHERE id IN ('A', '') ";

is the same as

query = " SELECT FROM tabella WHERE id = 'A' OR id = '' ";