String Matching

  • contains: Matches records where the field contains the specified substring.
  • startsWith: Matches records where the field starts with the specified prefix.
  • endsWith: Matches records where the field ends with the specified suffix.

Example:

$users = $prisma->user->findMany([
  'where' => [
    'name' => [
      'contains' => 'Rey',
      'startsWith' => 'R',
      'endsWith' => 'o'
    ]
  ]
]);