Spring JPA @Query with LIKE

by

Try to use the following approach (it works for me):

@Query("SELECT u.username FROM User u WHERE u.username LIKE CONCAT('%',:username,'%')")
List<String> findUsersWithPartOfName(@Param("username") String username);

Notice: The table name in JPQL must start with a capital letter.

More Related Contents:

  1. JQuery, Spring MVC @RequestBody and JSON – making it work together
  2. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  3. How to return a custom object from a Spring Data JPA GROUP BY query
  4. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  5. Spring Boot, Spring Data JPA with multiple DataSources
  6. Using generics in Spring Data JPA repositories
  7. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  8. Handling soft-deletes with Spring JPA
  9. Persistence unit as RESOURCE_LOCAL or JTA?
  10. @Transactional method called from another method doesn’t obtain a transaction
  11. Http Post request with content type application/x-www-form-urlencoded not working in Spring
  12. Implementing custom methods of Spring Data repository and exposing them through REST
  13. Spring – Is it possible to use multiple transaction managers in the same application?
  14. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  15. Spring-Data FETCH JOIN with Paging is not working
  16. Change database schema during runtime based on logged in user
  17. Why use returned instance after save() on Spring Data JPA Repository?
  18. Use abstract super class as parameter for Spring data repository
  19. How to use @Transactional with Spring Data?
  20. How to map sql native query result into DTO in spring jpa repository?
  21. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  22. JPA using multiple database schemas
  23. Iterating through a List Object in JSP
  24. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  25. Injecting EntityManager Vs. EntityManagerFactory
  26. DAO and Service layers (JPA/Hibernate + Spring) [duplicate]
  27. java.lang.IllegalStateException: No transactional EntityManager available
  28. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  29. How to find distinct rows with field in list using JPA and Spring?
  30. Does JPA support mapping to sql views?

Leave a Comment