Numerical Comparisons

  • lt: Matches records where the field value is less than the specified value.
  • lte: Matches records where the field value is less than or equal to the specified value.
  • gt: Matches records where the field value is greater than the specified value.
  • gte: Matches records where the field value is greater than or equal to the specified value.

Example:

$users = $prisma->user->findMany([
  'where' => [
    'age' => [
      'gt' => 20,
      'lt' => 30
    ]
  ]
]);