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