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

Created October 29, 2018 10:54

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aiiddqd/fb0a0a607b839d46680074e5350ab099.js"></script>
Save aiiddqd/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