More than 3 years have passed since last update.

【Rails】IN句の書き方

Posted at 2021-11-28

IN句の書き方いろいろ

User.where(id: [1, 3, 6])
#=> SELECT `users`.* FROM `users` WHERE `users`.`id` IN ('1', '3', '6')

ids = [1, 3, 6]
User.where('id IN (?)', ids)
#=> SELECT `users`.* FROM `users` WHERE (id IN (1, 3, 6))

User.where('id IN (?)', [1, 3, 6])
#=> SELECT `users`.* FROM `users` WHERE (id IN (1, 3, 6))

User.where('id IN (1, 3, 6)')
#=> SELECT `users`.* FROM `users` WHERE (id IN (1, 3, 6))