sql="select a from b where c=d";
if(cond<1)
sql+=" and e=f";
else if(cond==1)
sql+=" and g=h";
else
sql+=" and i=j";
改为一句SQL
if(cond<1)
sql+=" and e=f";
else if(cond==1)
sql+=" and g=h";
else
sql+=" and i=j";
改为一句SQL
调试欢乐多
是就会改
select a from b where c=d and ((cond<1 and e=f) or (cond=1 and g=h) or(cond>1 and i=j))
from b
where cond<'1' and (c=d and e=f)
or cond='1' and (c=d and g=h)
or cond>'1' and (c=d and i=j)
select @cond = 4;
if(@cond <=3)
select a from b where c=d and e=f
else if((@cond >3))
select a from b where c=d and g=h