Select Rails objects that include value in array attribute

Question

I have a Rails model called Box. Each Box object has a column :products, which is an array of strings that includes all the products that are being stored inside it at the time.

For each Box object, it is possible that the same value was stored in another Box.

Is there a query I can use to return all the Boxes that have value x stored in :products?

I know "where" works for finding objects with certain values, and with an array you might use "include?", but I'm having trouble working out a way to use either in this case, if it's at all possible.

Answer 1

There was an answer posted here before that worked well enough, but I looked around and found another query that was more succinct.

selected_boxes = Box.where("?=ANY(products)", x)

Where x is the value you are seeking in each object.