Skip to content

Instantly share code, notes, and snippets.

@marcbacon

marcbacon/WordPress-SQL.mysql

Last active April 13, 2016 14:05
Show Gist options
  • Save marcbacon/78d9182216ce252128266669e5619823 to your computer and use it in GitHub Desktop.
Save marcbacon/78d9182216ce252128266669e5619823 to your computer and use it in GitHub Desktop.
Download ZIP
Useful WordPress SQL queries.
Raw
WordPress-SQL.mysql
# Delete all unapproved comments
DELETE FROM wp_comments WHERE comment_approved = 0
# Test to see what pages are using a certain page template
SELECT * FROM `wp_postmeta` WHERE `meta_value` like 'page-library.php'
# Get a post by ID
SELECT * FROM `wp_posts` WHERE `ID` = 1128
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment