search

zhangzhenhuajack / spring-data-jpa-guide

spring-data-jpa-guide，Spring Data JPA实战，SpringDataJpa详解
http://www.jackzhang.cn/spring-data-jpa-guide/
363 stars 157 forks source link

JPA如何讲in查询返回的结果按in传入照顺序返回？ #54

Open shihp opened 1 year ago

shihp commented 1 year ago

没找到非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 queryDid(List dids, Integer code, List dids2);

zhangzhenhuajack commented 1 year ago

JPQL比较难，看你的顺序不是 order by Desc ?