mysql里如果compCode的值是C0014D38A070100C0015D0013A00000D0012A000001623861300952780801C0000D00A230000D00A002800D00A002900D00A001800D00A113500D00A001000D0010A00000D0010A00001D0011A00000D00A000100D00A084300

要根据compCode的值进行动态的SQL查询，可以使用MySQL的FIND_IN_SET函数来实现。以下是修改后的SQL语句：

<if test="compCode != null">
    and DELETED_ = 0
    and (FIND_IN_SET(COMP_CODE, #{compCode}) > 0 or FIND_IN_SET(SIGN_COMP_CODE, #{compCode}) > 0)
</if>

这样，当compCode的值为(C0014,D38A070100,C0015,D0013A00000,D0012A00000,1623861300952780801,C0000,D00A230000,D00A002800,D00A002900,D00A001800,D00A113500,D00A001000,D0010A00000,D0010A00001,D0011A00000,D00A000100,D00A084300)时，就可以正确执行查询语句，不会报错。