How Do You Bulk Update Status Of Subscribers?

Alex Read

Active Member
I have lots of subscribers who got moved to another list.

How do I bulk move them back and update their status?

(See attached)
 

Attachments

  • Update Status.jpg
    Update Status.jpg
    158.3 KB · Views: 15
i am using mysql command update status
example status "blacklisted" > "confirmed"

UPDATE `mw_list_subscriber` SET `status` = REPLACE(`status`, 'blacklisted', 'confirmed') WHERE INSTR(`status`, 'blacklisted') > 0;
 
Back
Top