Y
Hacker News
new
|
ask
|
show
|
jobs
by
adamzochowski
637 days ago
Can you expand on this? How is having
WHERE 1=1 AND ...[usual-where-clause]...
A performance and security compared to doing
WHERE ...[usual-where-clause]...
1 comments
AtNightWeCode
637 days ago
If you use it in the same way you use trailing commas. Fair. But the site says to make it easier to add dynamic conditions. Which is a terrible idea in maybe not all but many SQL engines.
link