How do I upsert multiple records

[milestones95]

Hi,

I have a table called Orders that has the "order_id" column and "status" column. I'd like to be able to select multiple orders at once on the front end and give them the same status. How can I do that? Thanks!

[inian]

If you just want to update the records you can do this @milestones95

supabase.from('orders')
.update({ status: "newstatus" })
.in('id', [1, 3, 4])

If you want to upsert, you can modify the above example to use upsert

[milestones95]

Thanks!! You're awesome

[milestones95]

How would I get the distinct count of all the orders based on a certain status?