模糊匹配n(n>=1)个字符串,匹配其一即可。
# includeStr =(str1|str2|str3...) excludeStr=(str1|str2|str3...)
select * from tab_temp where column_temp similar to CONCAT('%',#{includeStr, jdbcType = VARCHAR},'%') and not similar to CONCAT('%',#{excludeStr, jdbcType = VARCHAR},'%')
-- 例:查询包含字符串A或B或C,且不包含字符串D或E或F的column_temp列
select * from tab_temp where column_temp similar to '%(A|B|C)%' and not similar to '%(D|E|F)%';