关于某个字段的多项查询
这是从java中传到sql的一个Map:
{classification=(1,2,3,4)}
这是部分sql语句
<if test="classification != null and classification !=''">
AND classification in #{classification}
</if>
为什么查询会报错?
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''(1,2,3,4')' at line 9
谢谢各位大神不吝赐教!!!