mybaitis多条件批量删除，求大神帮忙

delete from tableName where id not in

#{item}

and
date in

#{item1}

我想做id不在某某范围内但是date在某某内的批量删除，求大神帮忙给个思路，为什么这么写不对呢，提示错误是绑定list错误，

http://www.cnblogs.com/liaojie970/p/5577018.html

假如说id不在[1,10),注意是左闭右开区间,就可以写成 where id between 1 and 10
所以这个条件就可以写成

delete from ... where id between 1 and 10 and date between 1 and 10

或者在写成这样
<![CDATA[
delete from ... where id>=1 and id =1 and date ]]>