mybatis模糊查询字符串拼接like
方法一:
<if test="projectName != null "> and project_name like concat('%',#{projectName},'%') </if>
方法二:
<if test="projectName != null "> <bind name="bindProjectName" value="'%'+projectName+'%'"></bind> and project_name like #{bindProjectName} </if>