mysql myBatis 模糊查询的写法

<select id="getFormatList" resultMap="FormatListRVO">
	<![CDATA[
		SELECT
			T.FORMAT_ID formatId,
			T.FORMAT_NAME formatName,
			T.START_PLACE startPlace,
			T.END_PLACE endPlace,
			T.PLAY_DAYS playDays,
			T.CREATE_TYPE createType,
			date_format(R.START_DATE, '%Y/%d/%m') startDate, //时间格式转换
			R.DEADLINE deadLine,
			R.END_DATE endDate
		FROM
			t_f_format T
		LEFT JOIN 
			t_f_release R ON T.FORMAT_ID = R.FORMAT_ID AND R.DELFLAG = 0 
		WHERE T.DELFLAG = 0
	]]>
	<if test="formatName != '' and formatName != null">
		AND T.FORMAT_NAME LIKE CONCAT('%',#{formatName},'%') //模糊查询
	</if>
		LIMIT #{begin},#{count}	//分页
	</select>