Home » Search

About like

1-10 of 200 Refresh
Manual
82

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
69

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
69

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
69

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
69

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
69

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
69

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
69

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
69

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
24

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