Drizzle TeamDT
Drizzle Team•3y ago
PGT

update where multiple conditions

Trying to do something like a:
UPDATE table SET values WHERE condition1 AND condition2

other ORMs will all you to pass in an object for conditions and they'll handle it under the hood, does Drizzle have something like this or do I need to do something like:

const query = db
    .update(Table)
    .set({ ...data, updatedAt: new Date() })
    .where(eq(condition1)
    .where(eq(condition2));
Was this page helpful?