Alex Read Active Member Dec 13, 2018 #1 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 158.3 KB · Views: 15
I have lots of subscribers who got moved to another list. How do I bulk move them back and update their status? (See attached)
frm.mwz Well-Known Member Dec 13, 2018 #2 Alex Read said: I have lots of subscribers who got moved to another list. How do I bulk move them back and update their status? (See attached) Click to expand... either in dbf or export, delete and re-import in old list
Alex Read said: I have lots of subscribers who got moved to another list. How do I bulk move them back and update their status? (See attached) Click to expand... either in dbf or export, delete and re-import in old list
Alex Read Active Member Dec 14, 2018 #3 Thanks. I thought there might be an easy option to 'move' selected subscribers to a set list.
S selcuk akbas New Member Dec 17, 2018 #4 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;
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;