mybatis like模糊查询特殊字符报错转义处理方式

    <if test="projectName!=null and projectName!=''">
            <bind name="projectName_" value="'%'+projectName+'%'"/>
            AND info.name like #{projectName_}
        </if>

    <if test="projectName!=null and projectName!=''">
            AND info.name like concat('%',#{projectName_},'%')
        </if>

import org.apache.commons.lang3.StringUtils; 
public class EscapeUtil {
    //mysql的模糊查询时特殊字符转义
    public static String escapeChar(String before){
        if(StringUtils.isNotBlank(before)){
            before = before.replaceAll("\\\\", "\\\\\\\\");
            before = before.replaceAll("_", "\\\\_");
            before = before.replaceAll("%", "\\\\%");
        }
        return before ;
    }
}