# SQL中的or与in的区别

or与in一样的案例（条件里只有a时）

a in (1,2,3)
a = 1 or a = 2 or a = 3

or与in不一样的案例（条件里不止a时）

where a in (1,3) and b = 2

where (a = 1 or a = 3) and b = 2

where a = 1 and b = 2 or a = 3 and b = 2

where (a = 1 and b = 2) or (a = 3 and b =2 )

where a in (1,3) and b = 2

where a = 1 or a = 3 and b = 2