Expression<Integer> locate(
Expression<String> x,
Expression<String> pattern,
Expression<Integer> from
)
Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
Warning: the order of the first two parameters of this method is reversed compared to the corresponding function in JPQL.
- Parameters:
x- expression for string to be searchedpattern- expression for string to be locatedfrom- expression for position at which to start search
- Return:
- expression corresponding to position
- Since:
- JPA 2.0