News for hackers. Stuff that matters.

A comment on SQL Tips and Tricks. Parent comment

Re:SQL Tips and Tricks by AtNightWeCode on Wednesday September 25, 2024 @11:21AM (#41648484)
Which is exactly what the site says. To insert dynamic conditions. I know that you can use 1=1 for the same reasons as trailing commas. But kinda obvious that this is not the case here.
[ Parent | on HN ]
Re:SQL Tips and Tricks by regexman1 on Thursday September 26, 2024 @07:20PM (#41664623)
Just to be clear I'm using it for the same reason as trailing commas.

If I'm inspecting a dataset I use WHERE 1=1 so I can add and remove conditions more easily.

I realise the confusion is in my wording of dynamic - I might amend the README.md to clarify. Thanks for the feedback!

[ Parent | on HN ]