updateMany with limit ?

[damitai]

Is there any way to do updateMany() with LIMIT ?
would be equivalent to UPDATE table WHERE ... LIMIT ... SQL

[ryands17]

In this case, you need to fetch the values first with the limit and then perform an updateMany using in in where passing the id's.

[damitai]

Yup, that can be a workaround... although 2 queries instead of 1 ...
Any idea if this is planned as a feature?

[ryands17]

Not yet, but I see you've opened a feature request.

[cwqt]

Great way to give yourself a double booking problem - been over a year on this, any update?

[saesbuba]

any updates on this feature?

[ludralph]

@saesbuba No updates yet but we do have it in our radar. See the issue here

[steven-tey]

Looks like this is supported in 6.3.0 onwards: https://www.prisma.io/docs/orm/reference/prisma-client-reference#updatemany