title: How to reduce this multiple and- and or- conditions in sql-statement?
body: <p>I´ve got an optimizing question about SQL. </p>
  
  <p>Is there a way to reduce this sql syntax: </p>
  
  <pre><code>Select * from TABLE 
  where 
  COLUMN != 'abc' and 
  COLUMN != 'def' and 
  COLUMN != 'xau' and 
  COLUMN != 'def' and 
  COLUMN != 'eag' and 
  COLUMN != 'dff' and 
  COLUMN != 'www' 
  </code></pre>
  
  <p>and second sql syntax</p>
  
  <pre><code>Select * from TABLE 
  where 
  COLUMN = 'abc' or 
  COLUMN = 'def' or 
  COLUMN = 'xau' or 
  COLUMN = 'def' or 
  COLUMN = 'eag' or 
  COLUMN = 'dff' or 
  COLUMN = 'www' 
  </code></pre>