Please change your code to this:

@Query("select i from Brand i where i.name like %:name% and i.reviewStage = :stage")
Page<Brand> getLikeName(@Param("name") String name, @Param("stage") ReviewStage stage, Pageable pageable);

or this one:

@Query(value = "select * from brand i where i.name like CONCAT('%', ?1, '%') and i.review_stage = ?2", nativeQuery = true)
List<Brand> getLikeName(String name, String reviewStage, Pageable pageable);