Also always __test__ your database updates doing a select FIRST, and checking the output of your where condition.
I learned this in the hard way, after a small mistake (but I was still a junior developer).
I wish there was a select prefix that would turn any delete or update into a query. So that you could remove a single keyword to actually execute it, further reducing the chance of unforeseen typos