sql语句防歧义例子

1.小于号

WHERE  m.userType <![CDATA[  <  ]]> 3

2.拼接模糊查询，用concat将多个字符合并成一个

<if test="fullName != null and fullName != '' ">
    AND name LIKE CONCAT('%',#{fullName},'%')
</if>
<if test="userName != null and userName != '' ">
    AND username LIKE CONCAT('%',#{userName},'%')
</if>