JPA findBy field ignore case

Question

How do I make findByIn search using IgnoreCase of <Field>? I tried to use findByNameIgnoreCaseIn and findByNameInIgnoreCase with no result. DB is Postgresql.

@Repository
public interface UserRepository {
    List<User> findByNameIgnoreCaseIn(List<String> userNames);
}

Answer 1

Try something like this:

List<User> findByNameInIgnoreCase(List<String> userNames);