title: Smarter code to query the same parameter from multiple columns?
body: <p>We have this very wide table that has 25 diagnosis code columns: </p>
  
  <pre><code>diag1, diag2, … diag25.
  </code></pre>
  
  <p>If I want to look for diagnosis code '12345' I need to write </p>
  
  <pre><code>diag1 ='12345' or diag2='12345' or diag3='12345'... or diag25='12345'
  </code></pre>
  
  <p>Is there a way to do something like this:</p>
  
  <pre><code>diag1-diag25 ='12345'
  </code></pre>