select * from table_a where c1=v1 or c2=v2 and c3=v3;
在Mysql数据库中先执行and,再执行or,如果先要执行or需要用括号括起来,如下:
select * from table_a where (c1=v1 or c2=v3) and c3=v3
select * from table_a where c1=v1 or c2=v2 and c3=v3;
在Mysql数据库中先执行and,再执行or,如果先要执行or需要用括号括起来,如下:
select * from table_a where (c1=v1 or c2=v3) and c3=v3