Skip to content

Instantly share code, notes, and snippets.

@uptimizt

uptimizt/delete-commentmeta-without-comments.sql

Created October 29, 2018 10:39
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/bf77160a0f956d2b39b775ae898f91d3 to your computer and use it in GitHub Desktop.
Save uptimizt/bf77160a0f956d2b39b775ae898f91d3 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress & SQL - delete commentmeta without comments
Raw
delete-commentmeta-without-comments.sql
DELETE cm
FROM wp_commentmeta as cm
LEFT JOIN wp_comments as c ON c.comment_ID = cm.comment_id
WHERE c.comment_ID is null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment