News for hackers. Stuff that matters.

A comment on Best practices for writing SQL queries. Parent comment

Re:Best practices for writing SQL queries by croes on Saturday April 10, 2021 @05:03PM (#26765091)
It's also easier if you want to comment out certain parts of your code during debugging.
[ Parent | on HN ]
Re:Best practices for writing SQL queries by scottmcdot on Saturday April 10, 2021 @06:28PM (#26765787)
On this, I like to also use

   Where 1 = 1
   And...
   And...
Which makes it easy to comment out specific filters.
[ Parent | on HN ]
Re:Best practices for writing SQL queries by Tostino on Saturday April 10, 2021 @07:08PM (#26766111)
Yup, my code is littered with WHERE true AND ...
[ Parent | on HN ]