JPQL (JPA) search substring
- by JavaBeginner
Hi, Im facing simple problem with searching entities by some (sub)string, which they might contain.
E.g. I have users user1, usr2, useeeer3, user4 and I will enter to search window "use" and I expect to return user1, useeer3, user4.
Im sure you know what I mean now. Is there any construction in JPA (JQPL)? It would be nice to search using WHERE somehow in named queries. Something like "SELECT u FROM User u WHERE u.nickname contains :substring"