java.sql.SQLSyntaxErrorException: Unknown column ‘Y560’ in 'where clause’
这个错误是字符串用$取值的错误
<if test="@Ognl@isNotEmpty(jobNos)">
and (
CONCAT(',',job_nos,',') like CONCAT('%,',${jobNos},',%')
)
</if>
用#号取值即解决此错误
<if test="@Ognl@isNotEmpty(jobNos)">
and (
CONCAT(',',job_nos,',') like CONCAT('%,',#{jobNos},',%')
)
</if>