sqlserver 时间段 和 关键字 查询 Mybatis

where <if test="!=null and !='' and !=null and !=''"> a.CREATE_DATE between #{} AND #{} AND </if> 1=1 <if test="pd.field1 !=null and pd.field1!=''"> AND ( a.LOG_TYPE LIKE ('%' + #{pd.field1} + '%') or a.LOG_CONTENT LIKE ('%' + #{pd.field1} + '%') or a.MODULE_LOG LIKE ('%' + #{pd.field1} + '%') or LIKE ('%' + #{pd.field1} + '%') or a.OPERATOR_ROLE LIKE ('%' + #{pd.field1} + '%') or LIKE ('%' + #{pd.field1} + '%') ) </if> </select>