# How to do UPDATE WHERE COLUMN IN (list)

**URL:** <https://www.ruby-forum.com/t/how-to-do-update-where-column-in-list/87103>\
**Category:** Rails\
**Created:** [February 28, 2007, 6:53am UTC](https://www.ruby-forum.com/t/how-to-do-update-where-column-in-list/87103 "2007-02-28T06:53:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![snacktime](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7feea3/32.png) [@snacktime](https://www.ruby-forum.com/u/snacktime)\
**Post date:** [February 28, 2007, 6:53am UTC](https://www.ruby-forum.com/t/how-to-do-update-where-column-in-list/87103/1 "2007-02-28T06:53:29Z")

</div>

What would be the correct way in AR to do “UPDATE WHERE COLUMN IN  
(a,b,c,d)”

Chris

---

<div class="post-metadata">

**Author:** ![snacktime](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7feea3/32.png) [@snacktime](https://www.ruby-forum.com/u/snacktime)\
**Post date:** [February 28, 2007, 2:31pm UTC](https://www.ruby-forum.com/t/how-to-do-update-where-column-in-list/87103/2 "2007-02-28T14:31:54Z")

</div>

ActiveRecord::update\_all

> **[ActiveRecord::Base](https://api.rubyonrails.org/classes/ActiveRecord/Base.html#M000999)**
>
> Active Record Active Record objects don't specify their attributes directly, but rather infer them from the table definition with which they're linked.