REGEXP in mybatis

Question

The red box part (,sum(if(Item_169 REGEXP '^[0-9]{1,12}(.[0-9]{1,5} )?$',Item_169,0))) The mybatis configuration file is passed in the background (the configuration file is received with ${}), and the entire sql is copied to the mysql database and runs normally; how to solve this problem

Answer 1

<![CDATA[expression content]]>
Try it