Why would a sql query have "where 1 = 1" [duplicate]

Question

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.

Are there benefits to this?

Duplicate: Why would someone use WHERE 1=1 AND in a SQL clause?

That question isn't an answer to this question.

Where-clause:

select * from table where 1=1 and sStatus not in ('status1','status2','status3')

No programming or if statements to push an and in there. A straight query.

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.

Answer 1

Was it dynamic queries? Sometimes that's helpful when building dynamic queries based on parameters that are optional.

Answer 2

If you automatically want to add restrictions to your query, it makes your life easier:

string sql = "SELECT * FROM table WHERE 1=1";

if (someflag) {
  sql += " AND valid = 1";
}

if (someotherflag) {
  sql += " AND special = 1";
}

execute(sql);

Without WHERE 1 = 1 you would in each case have to check if it's the first restriction you add (and then use WHERE ...) or if you already added some other restriction before (and then add AND ...).