Rails 3 + activerecord, the best way to "mass update" a single field for all the records that meet a condition

ruby-on-rails activerecord
jpw picture jpw · Feb 6, 2011 · Viewed 47k times · Source

In rails 3, using activerecord, is there a single-query way to set the :hidden field to TRUE for all records that meet a condition ... say, for example, :condition => [ "phonenum = ?", some_phone_number ]

If a single query cannot do it, what IS the optimal approach?

Answer

Dogbert picture Dogbert · Feb 6, 2011

Use update_all with the optional second parameter for the condition:

Model.update_all({ hidden: true }, { phonenum: some_phone_number})

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails: select unique values from a column

I already have a working solution, but I would really like to know why this doesn't work: ratings = Model.select(:rating).uniq ratings.each { |r| puts r.rating } It selects, but don't print unique values, it prints all values, including …

Read More
Rails: How do I create a default value for attributes in Rails activerecord's model?

I want to create a default value for an attribute by defining it in ActiveRecord. By default everytime the record is created, I want to have a default value for attribute :status. I tried to do this: class Task < …

Read More