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 as some of the ones listed here might not be supported in a particular store.
Table B.1. Query keywords
| Logical keyword | Keyword expressions |
|---|---|
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,
IsWithin |