Reference:
DataJPA:
https://docs.spring.io/spring-data/data-jpa/docs/2.2.8.RELEASE/reference/html/#project
The following table lists the keywords generally supported by the Spring Data repository query derivation mechanism. However, consult the store-specific documentation for the exact list of supported keywords, because some listed here might not be supported in a particular store.
Table B.1. Query keywords
| Logical keyword | Keyword expressions |
|---|---|
AND | And |
OR | Or |
AFTER | After,
IsAfter |
BEFORE | Before,
IsBefore |
CONTAINING | Containing,
IsContaining,
Contains |
BETWEEN | Between,
IsBetween |
ENDING_WITH | EndingWith,
IsEndingWith,
EndsWith |
EXISTS | Exists |
FALSE | False,
IsFalse |
GREATER_THAN | GreaterThan,
IsGreaterThan |
GREATER_THAN_EQUALS | GreaterThanEqual,
IsGreaterThanEqual |
IN | In, IsIn |
IS | Is, Equals, (or no
keyword) |
IS_NOT_NULL | NotNull,
IsNotNull |
IS_NULL | Null, IsNull |
LESS_THAN | LessThan,
IsLessThan |
LESS_THAN_EQUAL | LessThanEqual,
IsLessThanEqual |
LIKE | Like, IsLike |
NEAR | Near, IsNear |
NOT | Not, IsNot |
NOT_IN | NotIn,
IsNotIn |
NOT_LIKE | NotLike,
IsNotLike |
REGEX | Regex, MatchesRegex,
Matches |
STARTING_WITH | StartingWith,
IsStartingWith,
StartsWith |
TRUE | True, IsTrue |
WITHIN | Within
|