Always use SELECT-query with the same conditions before you DELETE/UPDATE in a production database.

I am always amazed when I see people who work with SQL much more than I do not test out their queries with SELECT first. And look at ALL the results returned, not just the first few. Yes, that last part was learned the hard way by myself when doing an UPDATE (thankfully before I did the commit).