mybatis like 使用

<select id="selectByBcIdLikeName" resultMap="PlayServiceWithPic_ResultMap"
            parameterType="java.util.Map">
        SELECT
        <include refid="PlayService_Column_List"/>
        ,
        <include refid="PlayServiceMultimedia_Column_List"/>
        FROM
        playservice AS ps

        LEFT OUTER JOIN playservicemultimedia AS psm ON ps.objectId = psm.serviceId

        WHERE
        ps.bcId = #{bcId,jdbcType=VARCHAR}
        and name like CONCAT('%',#{name,jdbcType=VARCHAR},'%' )
        AND ps.STATUS = 1
        AND UNIX_TIMESTAMP() > UNIX_TIMESTAMP(ps.saleStartTime)
        AND UNIX_TIMESTAMP() &lt; UNIX_TIMESTAMP(ps.saleEndTime)
        ORDER BY
        ps.orderField ASC,
        ps.updatedAt DESC,
        ps.createdAt DESC
</select>

<sql id="PlayService_Column_List">
        ps.objectId AS ps_objectId,
        ps.NAME AS ps_name,
        ps.bcId AS ps_bcId,
        ps.bcType AS ps_bcType,
        ps.saleCount AS ps_saleCount,
        ps.commentCount AS ps_commentCount,
        ps.starCount AS ps_starCount,
        ps.ageStart AS ps_ageStart,
        ps.ageEnd AS ps_ageEnd,
        ps.currentPrice AS ps_currentPrice,
        ps.price AS ps_price,
        ps.updatedAt AS ps_updatedAt,
        ps.starTotalCount AS ps_starTotalCount,
        ps.starTotalTimes AS ps_starTotalTimes
</sql>

<sql id="PlayServiceMultimedia_Column_List">
        psm.objectId AS psm_objectId,
        psm.url AS psm_url
</sql>