mybatis的">="、"<="、"like"

        <where>
            <if test="enterpriseName!=null">
                AND T.ENTERPRISE_NAME LIKE '%' #{enterpriseName,jdbcType=VARCHAR} '%'
            </if>
            <if test="startYearMonth !=null and startYearMonth !=''">
                AND <![CDATA[ T.YEARMONTH >= #{startYearMonth} ]]>
            </if>
            <if test="endYearMonth !=null and endYearMonth !=''">
                AND <![CDATA[ T.YEARMONTH <= #{endYearMonth}]]>
            </if>

            <if test="enterpriseAddress!=null">
                AND ENTERPRISE_ADDRESS LIKE CONCAT('%', #{enterpriseAddress,jdbcType=VARCHAR}, '%')
            </if>
        </where>

延伸：mybatis-plus对字段operate_time时间进行比较