mysema/querydsl — Issue #85: equalsIgnoreCase doesn't work with MongoDB
Author: blackcatcoding
Created: 2012-01-20 21:51:14+00:00
State: open

I've recently discovered that using the equalsIgnoreCase operation on a String property doesn't yield the desired result.

An example: I have two user acccounts "Rodney" and "Silvia". Even if I search for a part of one of the account's names, I get the account in the result set. So, code like this:

```java
QAccount.account.name.equalsIgnoreCase("R")
```
yields "Rodney" as result, but it shouldn't. I suspect you have implemented this using $regex with the i option. In this case you don't have to use "R" as search string, but rather "^R$".