mysql - 通过 JPA 存储库中的 native 查询然后通过 sql 查询获取不同的顺序

Question

我的 jpa 查询是

@Query(value="SELECT area FROM hoardings WHERE area LIKE %?1% GROUP by area order by instr(area, ?1)", nativeQuery=true)
    public List<String> searchByArea(String area);

它给出的顺序与我的 sql 查询不同

SELECT area FROM 'hoardings' WHERE 'area' LIKE '%n%' GROUP by area order by instr(area, 'n')

我认为 JPA native 查询不支持传递参数的顺序。有没有另一种方法来解决这个问题。谢谢

Answer 1

改为-

@Query(value="SELECT area FROM hoardings WHERE area LIKE %:area% GROUP by area order by instr(area, :area)", nativeQuery=true)
public List<String> searchByArea(String area);