[MyBatis] IN절의 조건 순서 그대로 정렬하는 방법

Published: 2019-07-16 by 놀이터흙이제맛

• Categories:
• mybatis 4

• Tags:
• dbms 32
• java 78
• mybatis 4

• MySQL 혹은 MariaDB
• Oracle

MySQL 혹은 MariaDB

SELECT PRD_ID
FROM   PRODUCT
WHERE PRD_ID IN (<foreach item="item" collection="prdIds" separator=",">#{item}</foreach>)
ORDER BY FIELD(PRD_ID, <foreach item="item" collection="prdIds" separator=",">#{item}</foreach>)

Oracle

SELECT PRD_ID
FROM   PRODUCT
WHERE PRD_ID IN (<foreach item="item" collection="prdIds" separator=",">#{item}</foreach>)
ORDER BY CASE PRD_ID <foreach item="item" collection="prdIds" separator=" " index="index">WHEN #{item} THEN #{index}</foreach> END

끗.