Page 1 of 1

Deleting recipients in the database

Posted: Thu Aug 04, 2011 9:09 am
by bla2508
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 :D

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.

Re: Deleting recipients in the database

Posted: Thu Aug 04, 2011 10:29 am
by joris1
Something like :

Code: Select all

delete FROM customer_1_tbl where customer_id not in (select customer_id from customer_1_binding_tbl);