spring-data-jpa-guide
spring-data-jpa-guide copied to clipboard
Published
20 hours ago •
zhangzhenhuajack
zhangzhenhuajack
JPA如何讲in查询返回的结果按in传入照顺序返回？
没找到非native的xiefa
直接用mysql native语法可以做到
SELECT * from models where id in (26612,26611,26610) order by field(id,26612,26611,26610);
@Query(value = "select * from dress where id in (?1) and source = ?2 order by field(id,?3)", nativeQuery = true) List<Dress> queryDid(List<Long> dids, Integer code, List<Long> dids2);
