4 ms·
WHERE T.first_name = "Ender" AND T.last_name = "Wiggins" versus WHERE T.first_name = "Ender" AND T.last_name = "Wiggins" you could also do WHERE 1=1 AN
by irrational 7y ago
WHERE
T.first_name = "Ender" AND
T.last_name = "Wiggins"
versus
WHERE
T.first_name = "Ender"
AND T.last_name = "Wiggins"
you could also do
WHERE 1=1
AND T.first_name = "Ender"
AND T.last_name = "Wiggins"
- 1996 7y agoThanks a lot, I thought it might have been WHERE 1=1 I will now use that to easily remove filters. An extension for the SELECT based on the very insightful top comment could be SELECT NULL ,something1 ,something2