title: Is there a way to search partial match in multivalue field in PostgreSQL?
body: <p>I have a table quiet like this:</p>
  
  <pre><code>CREATE TABLE myTable (
      family text,
      names text[]
  )
  </code></pre>
  
  <p>I can search like this:</p>
  
  <pre><code>SELECT family
  FROM myTable where names @&gt; array['B0WP04'];
  </code></pre>
  
  <p>But I would like to do:</p>
  
  <pre><code>SELECT family
  FROM myTable where names @&gt; array['%P0%'];
  </code></pre>
  
  <p>Is this possible ?</p>