Spring Boot

[JPQL] JPQL이 제공하는 모든 검색 조건

재원쓰 2023. 1. 20. 13:06
member.username.eq("member1") // username = "member1"
member.username.ne("member1") //username != "member1"
member.username.eq("member1").not() // username != "member1"

member.username.isNotNull // username != null

member.age.in(10, 20) // age in (10, 20)
member.age.notIn(10, 20) // age not in (10, 20)
member.age.between(10, 30) // age 10 ~ 30

member.age.goe(30) // (g)reat (o)r (e)qual : age >= 30
member.age.gt(30) // (g)reat : age > 30
member.age.loe(30) // (l)ow (o)r (e)qual : age <= 30
member.age.lt(30) // (l)ow : age < 30

member.username.like("member%") // like 검색
member.username.contains("member") // "%member%" 조건으로 like 검색
member.username.startWith("member") // "member%" 조건으로 like 검색