본문 바로가기
공부/QueryDSL

QueryDSL 공부하기 - 3

by 고구밍 2022. 5. 11.
member.username.eq("member1") // username = 'member1'
member.username.ne("member1") //username != 'member1'
member.username.eq("member1").not() // username != 'member1'
member.username.isNotNull() //이름이 is not 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) //between 10, 30
member.age.goe(30) // age >= 30
member.age.gt(30) // age > 30
member.age.loe(30) // age <= 30
member.age.lt(30) // age < 30
member.username.like("member%") //like 검색
member.username.contains("member") // like ‘%member%’ 검색
member.username.startsWith("member") //like ‘member%’ 검색

 

'공부 > QueryDSL' 카테고리의 다른 글

QueryDSL 공부하기 - 4 ( DTO조회 )  (0) 2022.05.13
QueryDSL 공부하기 - 2  (0) 2022.05.11
QueryDSL 공부하기 - 1  (0) 2022.05.10