Use array for filtering Prisma nextjs

Question

having an array with unique names, how can i update the elemets of those names using prisma(in nextjs). I mean something Like:

const arr=['Joe', 'Mark'];
const update=await prisma.user.updateMany({
    where: {
        name: //What should i put to update both Joe and Mark?
    },
    data: {
        notifications: {push: "Hello"}
    }
});

I'm using PSQL and i don't know if it matters.

user_14912872 · Answer

Try this:

const arr=['Joe', 'Mark'];

const update=await prisma.user.updateMany({
    where: {
        name: {in: arr}
    },
    data: {
        notifications: {push: "Hello"}
    }
});

"in" will check if name matches anything in that array. Here is the list of other filters: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#filter-conditions-and-operators

Use array for filtering Prisma nextjs

1 Answers