activityBuildItemId, activityBuildId, itemNo, itemName, itemEN, itemType, area, approveStatus, itemUrl, addTime select from sp_activity_build_item where activityBuildItemId = #{activityBuildItemId,jdbcType=BIGINT} select from sp_activity_build_item t and itemType=#{itemType,jdbcType=VARCHAR} and approveStatus=#{approveStatus,jdbcType=VARCHAR} AND ( itemNo like CONCAT('%', TRIM(#{keywords}), '%') OR itemEN like CONCAT('%', TRIM(#{keywords}), '%') OR itemName like CONCAT('%', TRIM(#{keywords}), '%') ) and activityBuildId=#{activityBuildId}