title: How to query array in Postgres json column?
body: <p>Thanks in advance. Assume, I have a table that contains the value in an array something like this.</p>
  <pre><code>CREATE TABLE example (
      id serial4 NOT NULL,
      name varchar(100) NOT NULL,
      content_type json NULL
      CONSTRAINT example_pkey PRIMARY KEY (id)
  );
  </code></pre>
  <pre><code>id |name |content_type
  -----------------------
   1 | P   | ['a','b','c']
   2 | Q   | ['a',]
   3 | R   | ['b','c']
   4 | S   | ['a','c']
  </code></pre>
  <p>I want to find which row contains <code>'c'</code> in content_type</p>
  <p>I have tried but couldn't get,</p>
  <pre><code>select * from table where ARRAY['c'] &amp;&amp; content_type;
  </code></pre>
  <p>Is there someone to help me to build the query?</p>