title: PostgreSQL: Select text that contains special characters
body: <p>I would like to make the selection of the following strings:</p>
  <pre><code>Pink
  Nando's
  M&amp;M's
  Banana
  Black &amp; White
  </code></pre>
  <p>As you can see there's a combination of words with and without special characters. The actual list is too long (&gt; 3k items), so I'd like to know the most generic way of making this selection as the following won't work:</p>
  <pre><code>select *
  from my_table
  where col1 in (
  'Pink',
  'Nando's',
  'M&amp;M's',
  'Banana',
  'Black &amp; White')
  </code></pre>
  <p>nor will using <code>LIKE '%my string%'</code></p>