查询条件为数组的sql->mapper

原SQL:

SELECT
	*
FROM
	tt_course
WHERE
	id IN (
		'14WGgoTEhBkc6iksGRWR1f',
		'18xingzhengban_1',
		'15bRg7W4dq3gCNKewk2cQ1'
	)

转为mapper:

SELECT
	 *
FROM
     tt_course
WHERE
     id in (
        <foreach collection="Ids" item="Ids" separator=",">
            #{Ids}
        </foreach>
     )

版权声明:本文为zhangjiahao7521原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。