求大神!使用后ibatis模糊查询报错
如果只有上面一个条件的话,正常,但是一旦多写了一个就报错
<select id="getGoodsByKeyword" parameterClass="string" resultClass="goods">
<!-- select * from goods where goodName like CONCAT('%', #name#, '%')-->
select * from goods
<dynamic prepend="WHERE">
<isNotEmpty>
goodName like CONCAT('%', #name#, '%')
</isNotEmpty>
<!--<isNotEmpty prepend="OR">
describe like CONCAT('%', #name#, '%')
</isNotEmpty>-->
<isNotEmpty prepend="AND">
type like CONCAT('%', #name#, '%')
</isNotEmpty>
</dynamic>
</select>
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 'type like CONCAT('%', '??', '%')' at line 1