Skip to content

Instantly share code, notes, and snippets.

@uptimizt

uptimizt/wordpress-mysql-delete-comments-1-year-ago.sql

Created October 29, 2018 10:54
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 uptimizt/fb0a0a607b839d46680074e5350ab099 to your computer and use it in GitHub Desktop.
Save uptimizt/fb0a0a607b839d46680074e5350ab099 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress & MySQL. Удаляем комментарии добавленные более года назад
Raw
wordpress-mysql-delete-comments-1-year-ago.sql
-- delete comments 1 year ago
DELETE c
FROM wp_comments as c
WHERE c.comment_date_gmt < DATE_SUB(NOW(),INTERVAL 1 YEAR)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment