Pedro Montoto García
Reputation: 1712
Update set with value in table rails
How can I do something like:
UPDATE table SET boolean = !boolean WHERE conditions
With an ActiveRecord model (Without using two queries)?
Upvotes: 0
Views: 922
Answers (1)
Taekmin Kim
Reputation: 151
users table in mysql
active : tinyint(2)
in rails console
User.update_all("active = !active", conditions)
Upvotes: 1
Related Questions
- Rails - update directly in SQL
- How can I update a specific column in an activerecord in Ruby on Rails?
- How to update an active record in ruby
- Ruby on rails: Update multiple records in rails
- Rails update a field with another field
- Rails 4 update_all and set value from another field
- Update ActiveRecord using row in Rails
- Update all records in a new table using ActiveRecord
- Update multiple rows with one query in rails
- Update using Active Record