@Update("update notification set read_status = 0 where uuid in(#{uuids})")
void setUUidNotificationToRead(@Param("uuids") String uuids);
@Update("update notification set read_status = 1 , msg = #{msg} ,code = #{code} ,handler_status = #{handler_status} where uuid = #{uuid} ")
void updateFromUserNotificationByUUid(String uuid, String msg, Integer code, Integer handler_status);
Mybatis模糊查询
<select id="selectByLikeUserName" parameterType="java.lang.String" resultMap="BaseResultMap">
<bind name="pattern" value="'' + username + '%'"/>
SELECT * from notification WHERE conversation_id like #{pattern}
</select>