Hi i have a new question.
I want to delete all recipient off a mailinglist but in the documentation is only the option to delete recipients over the targetgroup.
But i have no target groups
When i delete only one recipient i only remove the dependency off the mailinglists and not the recipient in the database.
Now i search a mysql query to delete the recipients restless in the database but i only want to delete the recipients off one mailinglist.
Thanks for your help.
Deleting recipients in the database
Moderator: moderator
Re: Deleting recipients in the database
Something like :
Code: Select all
delete FROM customer_1_tbl where customer_id not in (select customer_id from customer_1_binding_tbl);