BFTrick/sql-command.sql

Last active April 25, 2022 14:31

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/BFTrick/4957491.js"></script>
Save BFTrick/4957491 to your computer and use it in GitHub Desktop.

Download ZIP

A SQL command to delete all orphaned post meta data

Raw

sql-command.sql

	DELETE pm
	FROM wp_postmeta pm
	LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
	WHERE wp.ID IS NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment