mybatis 模糊查询 mapper.xml的写法
like模糊查询
like CONCAT(CONCAT('%', #{text}), '%')
例题:mapper.xml
select * from table where BEAN_NAME like CONCAT(CONCAT('%', #{beanName}), '%')
like CONCAT(CONCAT('%', #{text}), '%')
例题:mapper.xml
select * from table where BEAN_NAME like CONCAT(CONCAT('%', #{beanName}), '%')