有一个参数MNG，一个字段manage,如果len(manage)=5,则让MNG为86；
如果len(manage)=7,则截取MNG的前4位并传参给manage。
该怎么写？
where 1=1
${if(len(manage)=7," and manage='86'"," and manage="+left(MNG,4))}
为啥非要用IF啊，用Switch也可以的
${SWITCH(len(manage),5," and manage='86'",7,"and manage="+left(MNG,4))}
这种字段要放到IF里而且要做多个判断的，不适合放到IF里面，放到外面也可以，更方便
and manage = case when length(manage) = 5 then 86 when length(manage) = 7 then '${LEFT(MNG,4)}' end
1min目标场景问卷
立即参与
