Skip to content

Instantly share code, notes, and snippets.

@mohammadYousefiDev

mohammadYousefiDev/delete-orphans-usermeta.sql

Forked from carlosleopoldo/delete-orphans-usermeta.sql
Created April 1, 2021 13:48
Show Gist options
  • Save mohammadYousefiDev/3db4637a1f6cba8d495d65aab66c63f5 to your computer and use it in GitHub Desktop.
Save mohammadYousefiDev/3db4637a1f6cba8d495d65aab66c63f5 to your computer and use it in GitHub Desktop.
Download ZIP
Delete all orphans user meta in WordPress
Raw
delete-orphans-usermeta.sql
DELETE FROM wp_usermeta
WHERE NOT EXISTS (
SELECT * FROM wp_users
WHERE wp_usermeta.user_id = wp_users.ID
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment