Search code examples
ruby-on-railsruby-on-rails-3ruby-on-rails-4

How to write update all conditionally queries in rails4


I want rails queries similar to:

UPDATE users SET name="test" WHERE name="test1"

Solution

  • User.update_all({name: 'test'},{name: 'test1'}) # deprecated since Rails 4
    

    or

    User.where(name: 'test1').update_all(name: 'test')