SELECT count(1)
FROM xxl_job_group AS t
<trimprefix="WHERE"prefixOverrides="AND | OR"><iftest="appname != null and appname != ''">
AND t.app_name like CONCAT(CONCAT('%', #{appname}), '%')
</if><iftest="title != null and title != ''">
AND t.title like CONCAT(CONCAT('%', #{title}), '%')
</if></trim>
2、suffixOverrides
<updateid="updateUser"parameterType="map">
update user
<trimprefix="set"suffixOverrides=","suffix="where id = #{id}"><iftest="username!=null and username!=''">username= #{username},</if><iftest="paeeword!=null and paeeword!=''">paeeword= #{paeeword},</if></trim></update>