新手问题 Sinatra Sequel Postgresql hstore 查询的问题

tianbymy · April 23, 2015 · Last by tianbymy replied at April 23, 2015 · 1870 hits

dynamics 的字段类型为 hstore {"a"=>"aa", "b"=>"bb"} {"a"=>"a123", "b"=>"bbc"}

如何用 Model.where() 查询所有关于 dynamics 字段里面 a=%a% 的数据

1 likes

hz_qiuyuanxin #1 April 23, 2015

试试

Model.where("payload->'a' LIKE '%a%'")

tianbymy #2 April 23, 2015

where("dynamics -> 'a' LIKE 'aa'").all 刚刚研究出来

tianbymy #3 April 23, 2015

You need to Sign in before reply, if you don't have an account, please Sign up first.