JPA2: Case-insensitive like matching anywhere

JPA2: Case-insensitive like matching anywhere

In JPA (Java Persistence API) 2.0 or later, you can perform a case-insensitive "LIKE" query that matches a pattern anywhere in a text field (substring search) by using the LOWER function and the LIKE operator in your JPQL (Java Persistence Query Language) query. Here's an example of how to do this:

Let's assume you have an entity called Product with a field called name, and you want to find products whose names contain a specific substring in a case-insensitive manner.

@Entity public class Product { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; // Other fields, getters, and setters }

Now, you can write a JPQL query to perform a case-insensitive substring search using the LOWER function and the LIKE operator:

TypedQuery<Product> query = entityManager.createQuery( "SELECT p FROM Product p WHERE LOWER(p.name) LIKE LOWER(:searchTerm)", Product.class ); String searchTerm = "%yourSubstring%"; // Replace with the substring you want to search for query.setParameter("searchTerm", searchTerm); List<Product> resultList = query.getResultList();

In this query:

  • LOWER(p.name) converts the name field to lowercase, making the search case-insensitive.
  • LIKE is used for pattern matching.
  • :searchTerm is a named parameter that you can set using query.setParameter. Make sure to include % characters in the searchTerm to match the substring anywhere in the name field.

When you execute this query, it will return a list of Product entities that have names containing the specified substring in a case-insensitive manner.

Make sure you have an active EntityManager for your JPA context when executing the query, and replace Product with the name of your entity class as needed.

More Tags

moment-timezone magento2 stringr git-status es6-module-loader fieldofview layout-xml commoncrypto git-merge-conflict apache2

More Java Questions

More Organic chemistry Calculators

More Electrochemistry Calculators

More Geometry Calculators

More Bio laboratory Calculators