like clause with param in spring jpa
@Repository
public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
@Query("SELECT e FROM YourEntity e WHERE LOWER(e.propertyName) LIKE LOWER(CONCAT('%', :param, '%'))")
List<YourEntity> findByPropertyNameContainingIgnoreCase(@Param("param") String param);
}