Rails - update directly in SQL

Question

Delving into the documentation and the api, I seem to be missing how to update one field in multiple rows at once.

Something like

Table.select(:field).update("update to this").where(id: 4,5,6)

would be nice.

Does something like this exist? It would be much better than having to store everything in an array, set it to a value, and calling save every time.

Answer 1

You can use the update_all method, for example:

Table.update_all("field = 'update to this'", ["id in (?)", ids])

Answer 2

With newer Rails do this:

Table.where(id: [4, 5, 6]).update_all("field = 'update to this'")