ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh
160

LIKE wildcard with single character "_" behaves like a "*"

Hi, I've been using pattern matching with wildcards, and encountered an issue when dealing with the underscore character. The issue is that if it is placed at the end of the string, the "_" behaves like a "*". For example, if I have a query SELECT * FROM table1 WHERE (col1.name LIKE "ke
68

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> 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
68

like(x, pattern, escapeChar)

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

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> 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
68

like(x, pattern, escapeChar)

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

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<T> x, Expression<T> 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
68

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, Expression<String> 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
68

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<T> x, String pattern, Expression<T> 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
68

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, Expression<String> 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
55

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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support