User(id: integer, setting: jsonb)
User.where("setting ->> 'sequence' = ?", '1')

查询User setting字段,key为sequence 值为'1'的记录

SELECT  "users".* FROM "users" WHERE (setting ->> 'sequence' = '1') 
0条评论 顺序楼层
请先登录再回复