Difference between OR , AND with where in mysql -
i'm learning mysql
but felt confused after examples below :
select * `users` username = 'admin' or true;
here returned rows in users table !
(username = 'admin' or true ) should true ? true
but in example :
select * `users` username = 'admin' , true;
it returned 1 row (where username = 'admin')
but (username = 'admin' , true) should true !
so what's difference?
-- true 1 -- true rows username admin username = 'admin'
now check truth table:
x y | x , y | x or y ----------------------- f f | f | f f t | f | t t f | f | t t t | t | t
https://en.wikipedia.org/wiki/boolean_algebra
if take
x
where username = 'admin'
,y
where 1
you should understand results.
Comments
Post a Comment