title: SQL find '%' between %s
body: <p>I need to find (exclude in fact) any results that contain <code>'%'</code> sign, wherever in a string field. That would mean <code>... WHERE string LIKE '%%%'</code>. Googling about escaping gave me the following ideas. The first throws syntax error, the second returns rows but there are records actually contain <code>'%'</code>.</p>
  <p>1st:</p>
  <pre><code>SELECT * FROM table
  WHERE string NOT LIKE '%!%%' ESCAPE '!'
  ///tried with different escape characters
  </code></pre>
  <p>2nd:</p>
  <pre><code>SELECT * FROM table
  WHERE string NOT LIKE '%[%]%'
  </code></pre>
  <p>Trying on <code>GCP BigQuery</code>.</p>