SpringData JPA Repository Method Query with a like?

Question

In Spring-data JPA, is there anyway to create a method query that is essentially searches by like?? I have the following method query ``` public MakeModel findByModelIgnoreCase(String model); ``` What I really want is a like expression. Do I need to just create a Criteria or a @Query annotation? Am I asking too much? ``` //Stupid example of what I want to be able to do public MakeModel findByFuzzyModelIgnoreCase(String model); ``` Really I guess at the heart of it, I want to do a table search. I'm using Hibernate underneath Spring Data so I guess I could use some search api like Hibernate Search. I'm open to recommendations here.

Accepted Answer

Like is supported too:

```
MakeModel findByModelLikeIgnoreCase(String model);
```

When you call the method use the follwing: Add `"%"` at the start to say that it doesn't matter to be a strict start match , the same at the end, or you can use one of them it depends on the like you want.

```
MakeModel makeModel = findByModelLikeIgnoreCase("%"+model+"%");
```

if your make model Is `test` and the string to compare to is `"%"+model+"%"` then :

```
es is a match , T is a match , test is a match  
```

the string to compare to is `model+"%"`:

```
te is a match , es is not .
```

SpringData JPA Repository Method Query with a like?

Solution

Problem