cancel
Showing results for 
Search instead for 
Did you mean: 

Change the Subscriber status with SQL

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Change the Subscriber status with SQL

I would like to change the value of the subscriber_status in the table newsletter_subscriber

I have more than 2000 customer and I would like to do it with SQL.

 

Will the commande works ?

 

UPDATE `**MYTABLE**`.`newsletter_subscriber` SET `subscriber_status` = '1' WHERE `subscriber_status` =3;

 

In fact I would like to change only the status 3 to 1.

thanks for your help