Here is a cool way you can update columns in a table without writing any SQL using ActiveRecord. Suppose you have a form with checkboxes that are for deleting posts for the ones that are checked:
<input name="posts" type="checkbox" value="<%= post.id %>" />
Now you can update this in the method of your controller that this form posts to:
ActiveRecord will take of the fact that you want to update 1 record or multiple!