<select id="queryId" resultClass="ResultClass" parameterClass="list"> SELECT ... WHERE key IN <iterate open="(" close=")" conjunction=","> #list[]# </iterate> </select>