in my application user can give username or emailid to login how can i write the query like
select username,password from employee
where username='xxxx' or '[email protected]' and password='******'
how can i write the query so that user can give username or emailid to login. please send query for this problem thank u
You have given the query already. The only thing you need to do, is add braces so that the conditiosn are logically grouped together so that ...
Like this:
WHERE ( username = '' and password = '' ) or (email = '' and password = '' )
try this
select username,password from employee
where (username='xxxx' and password='******')
or (username='[email protected]' and password='******')
Solution:
select username,password from employee where (username='xxxx' or username='[email protected]') and password='******'
Why? There was operator precedence bug:
A or B and C === A or (B and C)
When no brackets specified AND operator has 1st priority. In boolean math AND op is like multiplication and OR op like addition in regular math.