Skip to content
masterclass Buddy
Start learning

Prisma · Concept

gt

Prisma Client lets you compare two fields from the same model in a non-unique filter. Use <model>.fields.<field> as the comparison value.

Last updated

Syntax

prisma.<model>.findMany({ where: { <field>: { <operator>: prisma.<model>.fields.<otherField> } } })

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • findMany
  • findUnique
  • findUniqueOrThrow
  • groupBy
  • having
  • by
  • Using Raw SQL

Source: Prisma Client API (Prisma ORM v7). Checked 2026-11-03.