pluck（）取表中一列中所有值组成数组

最新推荐文章于 2021-07-14 16:56:23 发布

qwbtc

最新推荐文章于 2021-07-14 16:56:23 发布

阅读量3.3k

点赞数

本文链接：https://blog.csdn.net/qwbtc/article/details/51305888

版权

######################！！！非常重要！！！！########################

###########pluck是取一个字段也就是一列的所有元素的值存入一个数组中，也可以取多个字段合

Person.pluck(:id)
# SELECT people.id FROM people
# => [1, 2, 3]

Person.pluck(:id, :name)
# SELECT people.id, people.name FROM people
# => [[1, 'David'], [2, 'Jeremy'], [3, 'Jose']]

Person.pluck('DISTINCT role')
# SELECT DISTINCT role FROM people
# => ['admin', 'member', 'guest']

Person.where(age: 21).limit(5).pluck(:id)
# SELECT people.id FROM people WHERE people.age = 21 LIMIT 5
# => [2, 3]

Person.pluck('DATEDIFF(updated_at, created_at)')
# SELECT DATEDIFF(updated_at, created_at) FROM people
# => ['0', '27761', '173']