DELETE FROM stats WHERE name=0
"name" is type VARCHAR(64). The above resulted in all records in the table being deleted, instead of just the 10~ that should have been affected. Only that many were actually equal to "0".
Why did this succeed in such cases as: "Mike"=0
Thankfully this was done on a personal development server and not production! I surely want to avoid this happening in the future.