How can i case insensitive check against a username?

where: { 
    username: username
}

it depends on your underlying provider. you should go through this chapter i believe: https://www.prisma.io/docs/concepts/components/prisma-client/case-sensitivity

yeah. but i con't want to match with endsWith or startsWith or contains, i want the exact match of the username, but not taking upper/lowercase letters into considerations.

didn’t work?

where: {
        username: {
          equals: username,
          mode: 'insensitive',
        },
      },

No, i'm getting:

error TS2322: Type '{ equals: any; mode: string; }' is not assignable to type 'string'.

@Halvor 👋 Case insensitivity will not work with

findUnique

. Only

findFirst

and

findMany

.