DELETE FROM `my_db`.`table_name` WHERE `email` = 'john@smith.com';