title: Postgres: Find matching array or array that contains t
body: <p>I'm using postgres 9.5 and have a table that looks something like this:</p>
  
  <pre><code>+----+--------------+-------------------------------+
  | id | string_field | array_field                   |
  |----+--------------+-------------------------------|
  | 1  | string a     | [apple, orange, banana, pear] |
  | 2  | string b     | [apple, orange, banana]       |
  | 3  | string c     | [apple, orange]               |
  | 4  | string d     | [apple, pear]                 |
  | 5  | string e     | [orange, apple]               |
  +----+--------------+-------------------------------+
  </code></pre>
  
  <p>Is it possible to query the DB for rows where <code>array_field</code> <strong>is, or contains</strong> <code>[apple, orange, banana]</code>? The results should return rows with id 1 and 2.</p>