Mybatis 时间段查询 和 模糊查询

<select id="queryWarnBranch" parameterType="com.chinalife.clap.common.Page" resultType="branch">  
		 select * from t_branch b
		 left join (select branchno as num, advancedays from t_warning w) w
    	 on w.num = b.branchno
		 where 1=1
		<if test="params.branchName != null and params.branchName !='' "> and branchName like '%'||#{params.branchName}||'%' </if>
		<if test="params.licenceNo != null and params.licenceNo !='' "> and licenceNo like '%'||#{params.licenceNo}||'%' </if>
		<if test="params.licenceType != null and params.licenceType !='' "> and licenceType like '%'||#{params.licenceType}||'%' </if>
		<if test="params.licStartDate != null and params.licStartDate !='' "> and licStartDate &gt;= #{params.licStartDate} </if>
		<if test="params.licEndDate != null and params.licEndDate !='' "> and licEndDate &lt;= #{params.licEndDate} </if>
		
		 order by crtTime desc 
	</select>