mybatis 模糊查询

select id="findProductByVender" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List"/>
    from
    t_full_product_${epcCode}
    <if test="oem!=null">
        where
        oem=#{oem,jdbcType=VARCHAR}
    </if>
    <if test="standName!=null">
        where
        stand_name like CONCAT('%',#{standName},'%')
    </if>
    order by create_time desc
</select>