How to use Boolean logic in a mySQL SELECT query

Question

How can I check if email = '$e' or username = '$e' inside my MySQL query.

Here is my MySQL query so far.

"SELECT user_id FROM users WHERE (email = '$e' AND pass=SHA1('$p'))"

codaddict · Accepted Answer · 2010-09-29 05:36:43Z

2

If you want to modify you existing query so that it works even if $e matches username, you can do:

SELECT user_id 
FROM users 
WHERE (email = '$e' OR username = '$e') AND pass=SHA1('$p')

answered Sep 29, 2010 at 5:36

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

1 Comment

I'd probably look at $e in your program, though, and decide if I want to treat it as either email or username.