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

by

If the list of conditions is not known at compile time and is instead built at run time, you don’t have to worry about whether you have one or more than one condition. You can generate them all like:

and <condition>

and concatenate them all together. With the 1=1 at the start, the initial and has something to associate with.

I’ve never seen this used for any kind of injection protection, as you say it doesn’t seem like it would help much. I have seen it used as an implementation convenience. The SQL query engine will end up ignoring the 1=1 so it should have no performance impact.

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Getting result of dynamic SQL into a variable for sql-server
  3. nvarchar(max) still being truncated
  4. How to use table variable in a dynamic sql statement?
  5. PostgreSQL parameterized Order By / Limit in table function
  6. Generate Delete Statement From Foreign Key Relationships in SQL 2008?
  7. Dynamic SQL to generate column names?
  8. SQL update fields of one table from fields of another one
  9. DROP FUNCTION without knowing the number/type of parameters?
  10. Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
  11. T-SQL: How to use parameters in dynamic SQL?
  12. PostgreSQL convert columns to rows? Transpose?
  13. Drop all tables whose names begin with a certain string
  14. COPY with dynamic file name
  15. Create PostgreSQL ROLE (user) if it doesn’t exist
  16. PostgreSQL – dynamic value as table name [duplicate]
  17. Count work days between two dates
  18. Rails raw SQL example
  19. Polymorphism in SQL database tables?
  20. Sql PIVOT and string concatenation aggregate
  21. Get previous and next row from rows selected with (WHERE) conditions
  22. Return multiple columns and rows from a function PostgreSQL instead of record
  23. Comma separated values in a database field
  24. SQL not displaying null values on a not equals query?
  25. SQL LIKE condition to check for integer?
  26. move cells left in sql if left contains null and right contains value
  27. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  28. Google Big Query SQL – Get Most Recent Column Value
  29. Copy table structure to new table in sqlite3
  30. How can I use SUM() OVER()

Leave a Comment