PostgreSQL search in json array?

Question

PostgreSQL

The table is like this:
id, comp
comp is json:

[
  {
    "character": "俄",
    "components": [
      "亻",
      "手",
      "戈"
    ]
  },
  {
    "character": "罗",
    "components": [
      "罒",
      "夕"
    ]
  },
  {
    "character": "斯",
    "components": [
      "甘",
      "一",
      "八",
      "斤"
    ]
  }
]

You need to search for components. For example, I need to find 夕, then they will return the full string
id, comp

Answer 1

SELECT * FROM some_table WHERE comp @> '{"components": ["夕"]}'