4 ms·
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
by adamzochowski 2y 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]...
- AtNightWeCode 2y agoIf 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.