select id,name
from test
where type_1 = 1 or type_2 = 1 and id = 1
这样会印出全部，无视了id=1这个条件，要怎么改才对呢?
------解决思路----------------------
select id,name
from test
where (type_1 = 1 or type_2 = 1) and id = 1
select id,name
from test
where type_1 = 1 or (type_2 = 1 and id = 1)
select id,name
from test
where (type_1 = 1 or type_2 = 1) and id = 1
要看你的实际需要