Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL: Remove orphaned wp_usermeta
DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)
DELETE FROM myprefix_usermeta WHERE user_id NOT IN (SELECT ID FROM myprefix_users)
@wpsmith

This comment has been minimized.

Copy link
Owner Author

wpsmith commented Feb 15, 2014

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