How to search in hash column

Question

How to search in hash column on Postgresql ?

product model

serialize :properties, Hash

product migration

add_column :products, :properties, :text

Answer 1

Try with

 Product.where("properties->>'foo' = 'bar'")

Answer 2

You can only use sql LIKE operation to search in the text column.

You can switch to postgresql that has native support of hstore columns or migrate to Rails 5 that support json type column. Rails documentation