Related: The WHERE Clause

What is the WHERE 1=1 Logic?

This logic is often used to create dynamic WHERE clauses by acting as a placeholder and ensures that subsequent WHERE conditions can be easily added using the AND clause (read more here).

General Syntax

SELECT column1, column2
FROM table_name
WHERE 1=1 -- always evaluates to True
    AND condition1
    AND condition2
    AND condition3
    ...

It simplifies the logic required to construct the WHERE clause and helps avoid errors related to missing or incorrect conjunctions like AND or OR.