like CONCAT(CONCAT('%', #{text}), '%')
例题:mapper.xml
select * from table where BEAN_NAME like CONCAT(CONCAT('%', #{beanName}), '%')