需求如下,有一个参数是write_dept,当这个参数为空时,给sql语句后面拼接is_show = '0' ,不为空时,什么都不拼,请问该怎么写,大佬给写详细点,最好我直接复制上就能用,谢谢大佬
${IF(length(write_dept)==0,"and is_shou='0'",'')}
${IF(len(write_dept)==0,"and is_shou='0'",'')}