Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

A thief

24 Posts 17 Posters 1 Views 1 Watching

M Miszou

Actually, I've gotten into the habit of adding a where 1=1 clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts with and. select * from tablename where 1=1 and condition1 and condition2 and condition3 In the above example, you can simply comment out (using --) any of the where clauses without worrying about trailing any leading or trailing and.

The StartPage Randomizer - The Windows Cheerleader - Twitter
R Offline
R Offline
Rama Krishna Vavilala

wrote on last edited by

#21

Neat! I ought to remember this!
1 Reply Last reply

0
L led mike

CPallini wrote:

My 5.

What about your 5? Are you trying to hijack this thread?
P Offline
P Offline
PIEBALDconsult

wrote on last edited by

#22

Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.
L 1 Reply Last reply

0
P PIEBALDconsult

Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.
L Offline
L Offline
led mike

wrote on last edited by

#23

PIEBALDconsult wrote:

a few months ago

I was just inducted today[^], that's why I made that comment ;)
1 Reply Last reply

0
L Lost User

select * from tablename where(1<2); Works on any database
Z Offline
Z Offline
Zhat

wrote on last edited by

#24

how about: Delete DumbAss from CP_List_Of_Jerks where DumbAss = 'onyang2' Better yet: Delete * from Life where DumbAss = 'onyang2'
1 Reply Last reply

0

Log in to reply

1
2