Jmohey Jmohey - 1 year ago 57
SQL Question

Rails where clause when something is stored as array

I am running rails 4.2, with a PG database.

I have an item stored in the database such as (model


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

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

Obviously this is not working - but how are you meant to do this in rails?

Answer Source

According to documentation, something like this should work:

Item.where('something @> ARRAY[?]::varchar[]', ['3'])
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download