How to use 'ESCAPE' in DynamicSQL ?

[lntlky7]

code

        var builder = SqlBuilder.select(selectList)
                .from(unit)
                .where();
        if (StringUtils.isNotEmpty(form.getCode())) {
            builder.and(code, SqlBuilder.isEqualTo(Short.valueOf(form.getCode())));
        }
        if (StringUtils.isNotEmpty(form.getSingle())) {
            builder.and(single, isLike(SQLUtil.likeDoubleSide(form.getSingle())));
        }
        if (StringUtils.isNotEmpty(form.getPlural())) {
            builder.and(plural, isLike(SQLUtil.likeDoubleSide(form.getPlural())));
        }
        List<Unit> modelList = mapper.selectPage(form.buildPage(), builder.build()
                .render(RenderingStrategies.MYBATIS3));

I want to use keyword ESCAPE for isLike. How to do? thanks.
like this: select * from unit where plural like ? escape ''

[jeffgbutler]

This is quite difficult to do now, unfortunately. It will be easier in the next release. I will make an update shortly, and add an example.

[lntlky7]

I had try some way to do this yestoday, like AbstractTwoValueCondition and AbstractNoValueCondition. but it doesn't work properly. if it could be updated, it would be a great help, thanks a lot.

[jeffgbutler]

@lntlky7 see here for an example: https://github.com/mybatis/mybatis-dynamic-sql/blob/master/src/test/java/examples/mysql/IsLikeEscape.java