Home » Search

About substring

11-17 of 17Refresh
Manual
24

JPA Criteria API Queries

, substring, ...). Collection expressions (isEmpty, isNotEmpty, isMember, isNotMember, size). Comparison
Manual
24

JPA Query Expressions (JPQL / Criteria)

, sqrt). String expressions (like, length, locate, lower, upper, concat, substring, ...). Data
Result
24

ObjectDB Object Database Features

(LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER OF, SIZE
Forum
3

order by string with numbers

  The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM Users u ORDER BY SUBSTRING(u.username,4)*1 ASC If you have other alternative for JPA
Issue
2

com.objectdb.o.InternalException: null

ParseException {         String dateOfBirthStr = personalNumber.substring(0, 8
Forum
2

Database size is much larger than expected (x2)

++){    Uris uri = new Uris();    String sLine;    sLine = sss.substring(rd.nextInt(100));    uri
Forum
2

Partial Indexing

I have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA Currently ObjectDB supports only indexing