Select distinct by column in Active Record - Ruby on Rails

Question

I have 2 tables:

1. Post table (:id, :content)
2. Comment table (:id, :post_id, :content)

I'm using this code:

@result = Comment.where("content LIKE :query", query: "%#{@keyword}%")

@result has more dupplicated posts, how can I select unique collection by DISTINCT :post_id Thanks for your help!

how can there be duplicated values? a post can have many comments where post_id is the same. a post can have 5 comments including the text "foo" — Tim Kretschmer, Aug 13 '15 at 08:20

score 1 · Answer 1 · answered Aug 13 '15 at 08:18

1

just for the record another solution

@result = Comment.where("content LIKE :query", query: "%#{@keyword}%").group(:post_id)

answered Aug 13 '15 at 08:18

Tim Kretschmer

1 Answers1