测试的时候输入一个华东可以查询出来，当输入华东,华北查出来是空，应该怎么写
select * FROM S订单 as 订单 where 货主地区 is not null ${if(len(地区)=0,"","and 货主城市 in ('"+SUBSTITUTE(地区,",","','")+"')")}
-----------------------------------------------------
地区 in ('"+SUBSTITUTE(地区,",","','")+"')
1min目标场景问卷
立即参与
