Skip navigation.

Bar Solutions

Syndicate content
The beginning of knowledge is the discovery of something we do not understand. [Frank Herbert] 2015-03-22T07:30:55Z WordPress
Updated: 17 hours 55 min ago

What’s this ‘WHERE 1=1′?

Sun, 2015-03-22 01:30
Since some time I have been adding WHERE 1=1 to all my queries. I get queries like this: SELECT * FROM emp e WHERE 1=1 AND e.ename LIKE 'A%' AND e.deptno = 20 Lots of people ask me what’s the use of this WHERE 1=1. You know I like [...]