title: How to filter table by if any of the columns contains a x value
body: <p>How to write a where clause that filters any rows that equal to <code>Not or NO</code>.</p>
  <p>The challenge is, the data has to many columns, so I need to avoid writing a specific where for each column like <code> where a not in (&quot;Not&quot;,&quot;NO&quot;) and b a not in (&quot;Not&quot;,&quot;NO&quot;)</code> and so on.</p>
  <p>That doesn't work because there are too many columns.</p>
  <p>Table:</p>
  <pre><code>name    a    b    c     d    e   (so on... there are lots more column)
  
  joe    good  yes  Not   NO    yes
  mike   yes   yes  yes   good  well 
  louis  Not   yes  NO    yes   NO 
  jhon   yes   NO   well  Not   yes
  </code></pre>
  <p>Desired output:</p>
  <pre><code>name    a    b    c      d    e 
  
  mike   yes   yes  yes   good  well
  </code></pre>