用keyword接收用户输入内容,与库中usename,name或者mobile字段匹配满足一个即可查出:
SELECT * FROM *
WHERE 1 = 1
<if test="keyword != null and keyword != ''">
AND concat(username, name, mobile) LIKE concat('%',#{keyword},'%')
</if>
用keyword接收用户输入内容,与库中usename,name或者mobile字段匹配满足一个即可查出:
SELECT * FROM *
WHERE 1 = 1
<if test="keyword != null and keyword != ''">
AND concat(username, name, mobile) LIKE concat('%',#{keyword},'%')
</if>