Rails where where when something is stored as an array

Question

I am running rails 4.2 with a PG database.

I have an item stored in a database such as (model Item ):

 :something => ["1", "2", "3"] 

I would like to get Item.where(:something.include? => "3")

Obviously, this does not work - but how are you going to do it on rails?

Answer 1

According to the documentation , something like this should work:

 Item.where('something @> ARRAY[?]::varchar[]', ['3']) 

Answer 2

In addition to @potashin's answer, there is a shorter way (see the documentation ) if you need to get elements on one element.

 # Items for a single something Item.where("'3' = ANY (something)") # Or using '?' Item.where('? = ANY (something)', '3') # Items for multiple something Item.where('something @> ARRAY[?]::varchar[]', ['3', '4'])