쿼리가.. 뭐가 잘못된듯..
처리 완.
@Query("""
SELECT p FROM Post p
WHERE p.user.id NOT IN :blockedUserIds
AND (LOWER(p.title) LIKE LOWER(CONCAT('%', :keyword, '%'))
OR LOWER(p.content) LIKE LOWER(CONCAT('%', :keyword, '%')))
""")
Page<Post> searchByKeyword(@Param("keyword") String keyword,
@Param("blockedUserIds") List<Long> blockedUserIds,
Pageable pageable);
Java
복사