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 keywords listed here might not be supported in a particular store.
Table 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_EMPTY
|
IsEmpty, Empty
|
IS_NOT_EMPTY
|
IsNotEmpty, NotEmpty
|
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
|