title: Why would a sql query have "where 1 = 1"
body: <p>I was going through a few queries I am maintaining, and a programmer had put in the queries "where 1=1"  to me that always seems to evaluate to true.</p>
  
  <p>Are there benefits to this?</p>
  
  <p><strong>Duplicate:</strong> <a href="https://stackoverflow.com/questions/242822/why-would-someone-use-where-11-and-conditions-in-a-sql-clause">Why would someone use WHERE 1=1 AND  in a SQL clause?</a></p>
  
  <p>That question isn't an answer to this question.  </p>
  
  <p>Where-clause:</p>
  
  <pre><code>select * from table where 1=1 and sStatus not in ('status1','status2','status3')
  </code></pre>
  
  <p>No programming or if statements to push an and in there.  A straight query.</p>
  
  <p>If you could un-close this, I would like to know whether there is a purpose so that I may rewrite and remove the 1=1 if it is unnecessary.</p>