参数下拉复选框可以同时查询NULL和空值吗?
select name,school from db where 1=1 ${if(len(name) == 0,"","and name in ('" + name + "')")} ${if(len(school) == 0,"",if(school == "空",("and ISNULL(school)||school = ''"),"and school in ('" + school + "')"))}
执行结果,name筛选不起作用,请教各位大神应该怎么修改?
设置参数name=a school="空"
47856
执行结果为
47858