[SOLVED] Mass delete emails from table ps_emailsubscription

[c64girl]

I have a list of dead emails from table ps_emailsubscription. Anyone know how i can delete them using csv file or a sql question?

 

I was thinking about

DELETE FROM ps_emailsubscription myTable WHERE email in ('[email protected]', '[email protected]');

 

But what about registered users? I will need to change 1 to 0?

 

Edit:

Ok i did and it worked
UPDATE ps_customer SET newsletter = 0 WHERE email in ('email1', 'email2');

 

Edited July 3, 2023 by c64girl (see edit history)