Skip to content

Instantly share code, notes, and snippets.

@anton-roos

anton-roos/sendy.sql

Last active April 9, 2020 10:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anton-roos/47b2b41a741d4bca6c28d4fa4c6caef5 to your computer and use it in GitHub Desktop.
Save anton-roos/47b2b41a741d4bca6c28d4fa4c6caef5 to your computer and use it in GitHub Desktop.
Download ZIP
Sendy SQL Queries
Raw
sendy.sql
/* Delete all bounced email addresses from list 13 */
DELETE FROM `subscribers` WHERE `bounced` = 1 AND `list` = 13;
/* Delete all marked as spam email addresses from list 5 */
DELETE FROM `subscribers` WHERE `complaint` = 1 AND `list` = 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment