sql server sql query

Question

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

@surya: then you should do the polite and proper thing and accept the best answer / the one that really solved you problem. To accept the answer, please click on the check mark to the left of the answer below the "0" with the up- and down-arrow. If someone helps you - please be so kind as to accept the answer. — marc_s
– marc_s, Commented Sep 14, 2009 at 9:19

user170442 · Accepted Answer · 2009-09-14 09:04:33Z

4

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.

answered Sep 14, 2009 at 9:04

user170442

Sign up to request clarification or add additional context in comments.

1 Comment

user170442 Over a year ago

You are welcome! Question answer mark would be very appreciated :)

Frederik Gheysels · Accepted Answer · 2009-09-14 09:02:16Z

0

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 = '' )

answered Sep 14, 2009 at 9:02

Frederik Gheysels

57.2k12 gold badges103 silver badges156 bronze badges

1 Comment

marc_s Over a year ago

@surya: then you should do the polite and proper thing and accept the answer - click on the check mark to the left of the answer below the "0" with the up- and down-arrow. If someone helps you - please be so kind as to accept the answer.

Preet Sangha · Accepted Answer · 2009-09-14 09:03:23Z

0

try this

select username,password from employee 
where (username='xxxx' and password='******') 
or (username='[email protected]' and password='******')

edited Sep 14, 2009 at 9:03

Preet Sangha

65.7k20 gold badges152 silver badges227 bronze badges

answered Sep 14, 2009 at 9:02

RRUZ

137k20 gold badges365 silver badges489 bronze badges

Collectives™ on Stack Overflow

sql server sql query

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related