About substring

11-17 of 17Refresh
Manual
20

JPA Query Expressions (JPQL / Criteria)

, sqrt). String expressions (like, length, locate, lower, upper, concat, substring, ...). Data
Manual
20

FROM clause (JPQL / Criteria API)

, SUBSTRING, SUM, THEN,TRAILING, TRIM, TRUE, TYPE, UNKNOWN, UPDATE, UPPER, VALUE, WHEN, WHERE. JPQL
Manual
20

JPA Criteria API Queries

, substring, ...). Collection expressions (isEmpty, isNotEmpty, isMember, isNotMember, size). Comparison
Forum
2

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