ontheway365

 
<!-- NOTE:internal_name_trim使用的是偽列，而不是數(shù)據(jù)庫(kù)返回的數(shù)據(jù) -->
<select id="listByStoreIdAndPartsNoTrimAndBrandName" resultMap="productMap">
 SELECT
   product_id,
   internal_name_trim
 FROM (
   <foreach collection="productQuerys" item="productQuery"
   separator="UNION ALL" index="index">
     (SELECT
       product_id,
       @myInternalName#{index} as internal_name_trim
     FROM
     product,(SELECT @myInternalName#{index}:= #{productQuery.internalNameTrim}) r
     WHERE
     product_store_id = #{productStoreId}
     AND partsno_trim = #{productQuery.partsNoTrim}
     AND brand_name = #{productQuery.brandName}
     LIMIT 1)
   </foreach>
 ) p
 </select>