Skip to content

Instantly share code, notes, and snippets.

@breun

breun/trim_spam_subjects.sql

Created July 29, 2018 22:40
Show Gist options
  • Save breun/762f026b1824e00b51759dff30f22e6e to your computer and use it in GitHub Desktop.
Save breun/762f026b1824e00b51759dff30f22e6e to your computer and use it in GitHub Desktop.
Download ZIP
Remove '***Spam*** ' prefix from message subjects in Apple Mail (V5 format)
Raw
trim_spam_subjects.sql
UPDATE subjects SET subject = substr(subject,12), normalized_subject = substr(normalized_subject,12) WHERE subject LIKE '***Spam*** %';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment