表名:muscle_groups字段:id,名称,segment_ids数据:
{"f": [], "m": [31, 32, 33, 34, 35, 36, 38, 39]}
尝试了许多变体,如:
select id, name, segment_ids->>"m"
where 5 = any(json_array_element(segment_ids->>"m")
您正在查找包含运算符@>
select *
from muscle_groups
where segment_ids @> '{"m": [5]}'