Spring JPA Query with LIKE

Question

I m trying to make a method in CrudRepository that will be able to give me list of users  whose usernames are LIKE the input parameter not only begin with  but also contains it   I tried to use method  findUserByUsernameLike  Param  username   String username   but as it is told in Spring documentation  this method is equal to   where user username like  1   It is not good for me  as I already told that I m trying to get all users whose username contains       I wrote a queryto the method but it even doesn t deploy    Repository public interface UserRepository extends CrudRepository lt User  Long gt      Query  select u from user u where u username like   username     List lt User gt  findUserByUsernameLike  Param  username   String username       Can anybody help me with this

User · Answer

For your case  you can directly use JPA methods  That is like bellow   Containing  select     like   username   List lt User gt  findByUsernameContainingIgnoreCase String username     here  IgnoreCase will help you to search item with ignoring the case   Here are some related methods    Like findByFirstnameLike      where x firstname like  1 StartingWith findByFirstnameStartingWith      where x firstname like  1  parameter bound with appended    EndingWith findByFirstnameEndingWith      where x firstname like  1  parameter bound with prepended    Containing findByFirstnameContaining      where x firstname like  1  parameter bound wrapped in      More info   view this link and this link  Hope this will help you

User · Answer

You Missed a colon    before the username parameter  therefore your code must change from   Query  quot select u from user u where u username like   username   quot    to    Query  quot select u from user u where u username like    username   quot

User · Answer

Query  select u from user u where u username LIKE  username   List lt User gt  findUserByUsernameLike  Param  username   String username

User · Answer

List lt User gt  findByUsernameContainingIgnoreCase String username     in order to ignore case issues

User · Answer

Easy to use following  no need use CONCAT or        Query  from Service s where s category typeAsString like  parent    List lt Service gt  findAll  Param  parent   String parent     Documented in  http   docs spring io spring-data jpa docs current reference html

User · Answer

Query  select b equipSealRegisterId from EquipSealRegister b where b sealName like   1  and b deleteFlag    0         List lt String gt findBySeal String sealname     I have tried this code and it works

User · Answer

Another way  instead CONCAT function we can use double pipe   lastname            Query  select c from Customer c where c lastName LIKE  lastname        List lt Customer gt  findCustomByLastName   Param  lastname   String lastName     You can put anywhere  prefix  suffix or both     lastname                 lastname           lastname

User · Answer

Using Query creation from method names  check table 4 where they explain some keywords    Using Like  select     like  username  List lt User gt  findByUsernameLike String username     StartingWith  select     like  username   List lt User gt  findByUsernameStartingWith String username     EndingWith  select     like   username  List lt User gt  findByUsernameEndingWith String username     Containing  select     like   username   List lt User gt  findByUsernameContaining String username      Notice that the answer that you are looking for is number 4  You don t have to use  Query

User · Answer

This way works for me   using Spring Boot version 2 0 1  RELEASE     Query  SELECT u username FROM User u WHERE u username LIKE   1    List lt String gt  findUsersWithPartOfName  Param  username   String username     Explaining  The  1   2   3 etc  are place holders the first  second  third parameters  etc  In this case is enough to have the parameter is surrounded by   as if it was a standard SQL query but without the single quotes

User · Answer

Try to use the following approach  it works for me     Query  SELECT u username FROM User u WHERE u username LIKE CONCAT      username        List lt String gt  findUsersWithPartOfName  Param  username   String username     Notice  The table name in JPQL must start with a capital letter

[java] Spring JPA @Query with LIKE

Examples related to java

Examples related to jquery

Examples related to sql

Examples related to spring

Examples related to jpa