Numerical Comparisons
Use lt, lte, gt, and gte to filter number fields by ranges or thresholds.
Comparison Operators
Numerical comparison operators allow filtering records based on numerical conditions:
- lt — Matches values less than the given number.
- lte — Matches values less than or equal to the given number.
- gt — Matches values greater than the given number.
- gte — Matches values greater than or equal to the given number.
These filters can be combined to create range-based queries.
Example Usage
$users = $prisma->user->findMany([
'where' => [
'age' => [
'gt' => 20,
'lt' => 30
]
]
]);