3 ms·
Interesting. Can you please provide an example of what you mean?
by 1996 7y ago
Interesting. Can you please provide an example of what you mean?
- irrational 7y agoWHERE 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