Is there a way to dynamically create regex expressions in mybatis xml mappers?

[ghevge]

Is there a way to dynamically create regex expressions in mybatis xml mappers?

I'm trying to create a dynamic regex to be used in a query from within an xml mapper. Something on this line:

<select id="getEqualContentsIgnoringSpaces" resultMap="ContentResultMap">
      	SELECT * FROM contents
        WHERE locale = #{locale}
        AND TRIM(value) ~ '^[\s]{0,}' + ${content} + '[\s]{0,}$'
     </select>

Obviously the way I've shown above doesn't work.

I've also tried to use the bind pattern approach but without luck.

Do you have any suggestion?

The resulting regex pattern should be '^[\s]{0,}my content here[\s]{0,}$'

Thanks

[harawata]

Hello @ghevge ,

You should be able to use CONCAT function.

AND TRIM(value) ~ CONCAT('^[\s]{0,}', #{content}, '[\s]{0,}$')

This may be off-topic, but the regular expression looks useless as you use TRIM.