Mybatis关于like的字符串模糊处理

其中通过"%"#{key}"%"来拼接语句 

<sql id="select_where">
from cellphone c left join client cl on c.client=cl.id left join
client cli on c.receiver=cli.id
<if test="key!=null">
where phone_brand like "%"#{key}"%" or phone_model like
"%"#{key}"%" or IMEI like
"%"#{key}"%"
</if>
order by id desc limit #{pageIndex},#{pageSize}
</sql>

原文地址:https://www.cnblogs.com/maybo/p/5183722.html