select with iterate

[Jason Punzalan]

Can someone show me an example of doing a select with iterate? Is it possible to do the following....

    <statement id="getAllByList" resultClass="Content" parameterClass="Content" resultMap="content-result" >
        <dynamic>
            <iterate property="idList">
                select * from content where
                id = #idList[]#
            </iterate>
        </dynamic>
    </statement>

I'm currently getting an java.sql.SQLException...running mysql.

Thanks