problem with or

[felito]

i want to catch the `password` of a specif email when the value of activation is 1 or 2

 

query that i am using:

 

    SELECT password FROM users WHERE email= "mail@gmail.com" && activation=1 OR activation=2

 

this code catches all emails that have `activation = 2`, but my idea is only catch `mail@gmail.com` if the value of `activation` is 1 or 2.

 

any idea?

 

thanks

 

[Maq]

You need parentheses:

WHERE email= "mail@gmail.com" AND (activation=1 OR activation=2)

[fenway]

You should NEVER need to retrieve the password.