About like

1-10 of 200Refresh
Manual
77

Strings in JPQL and Criteria Queries

to persistent string fields. as results of predefined JPQL string manipulation functions. LIKE - String Pattern Matching with Wildcards The [NOT] LIKE operator checks if a specified string matches ... literal). For example: c.name LIKE '_r%' is TRUE for 'Brazil' and FALSE for 'Denmark' c.name LIKE
JPA Doc
63

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   String pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   Expression pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   String pattern,   Expression escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character expression Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   Expression pattern,   char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression escapeChar - escape character Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   String pattern,   char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   Expression pattern,   char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression escapeChar - escape character Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   String pattern,   Expression escapeChar ) Create a predicate for testing whether the expression ... character expression Returns: like predicate Since: JPA 2.0
JPA Doc
63

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like(   Expression x,   Expression pattern,   Expression escapeChar ) Create a predicate for testing ... expression escapeChar - escape character expression Returns: like predicate Since: JPA 2.0
Forum
22

Help with 'not like/lower' query

Criteria with a combination of LOWER/UPPER - NOT LIKE: SELECT COUNT($1.id) FROM User $1 WHERE ($1.owningCompany=:p1) AND LOWER($1.email) NOT LIKE :p2 So in essence, I'm trying to do a count ... (Operator.LIKE)){ predicate = criteriaBuilder.like(criteriaBuilder.lower(path), stringProp