cancel
Showing results for 
Search instead for 
Did you mean: 

Change the Subscriber status with SQL

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