例:如下为模糊查询user表昵称字段:
<select id="selectUserByKeyword" resultType="com.ygxk.lws.modules.user.entity.UserEntity">
select * from user
where nickName
LIKE CONCAT('%',#{keyword},'%')
</select>
例:如下为模糊查询user表昵称字段:
<select id="selectUserByKeyword" resultType="com.ygxk.lws.modules.user.entity.UserEntity">
select * from user
where nickName
LIKE CONCAT('%',#{keyword},'%')
</select>