Edit History

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');

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');

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?

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 myTable WHERE email in ('[email protected]', '[email protected]');