title: How to query values with wildcards in PostgreSQL hstore
body: <p>I'm trying to query hstore for all the values of a certain key that match a search criteria. </p>
  
  <p>I can get all the values for a certain key like this:</p>
  
  <pre><code>SELECT DISTINCT
  svals(slice(data, ARRAY['Supplier']))
  FROM "products"
  </code></pre>
  
  <p>I can also get a specific value:</p>
  
  <pre><code>SELECT DISTINCT
  svals(slice(data, ARRAY['Supplier'])) AS sup
  FROM "products"
  WHERE data @&gt; 'Supplier =&gt; Toshiba'
  </code></pre>
  
  <p>What I would really like is something like (this doesn't work):</p>
  
  <pre><code>SELECT DISTINCT
  svals(slice(data, ARRAY['Supplier'])) AS sup
  FROM "products"
  WHERE data @&gt; 'Supplier =&gt; %tosh%'
  </code></pre>
  
  <p>or:</p>
  
  <pre><code>SELECT DISTINCT
  svals(slice(data, ARRAY['Supplier'])) AS sup
  FROM "products"
  WHERE lower(sup)
  LIKE '%tosh%'
  </code></pre>
  
  <p>for case-insensitive search. How is this done?</p>