Exact case insensitive match in spring-data mongo

Question

I am using spring data with mongo, and a repository. Eg:

@Query("{ 'userName' : ?0 }")
public User findByUsername(String username);

I want to make this case insensitive. I have used the following queries:

"{'userName' : { $regex : ?0, $options: 'i' } }"

This works, but it not only matches testUser, but also estUser.

I also tried

"{'userName' : { $regex : ^?0$, $options: 'i' } }"

But this cannot parse the query, because it tries to insert quotes in the regex.

com.mongodb.util.JSONParseException: 
({ $regex : ^"testUser"$, $options: 'i' }
            ^

I get the same kind of problems if I try to use a /.../i regex.

Is there any solution for this, without having to use mongoTemplate, or constructing the regex myself?

Answer 1

I just tried the following and it worked for me.

 @Query(value = "{'name': {$regex : '^?0$', $options: 'i'}}")
    List<Item> findItemsByNameRegexExactMatch(String name);

Answer 2

^ for the start, $ for the end

Aggregation aggregation = newAggregation( match(Criteria.where("fieldName").regex("^"+searchText+"$","i")) );