Skip to content

Instantly share code, notes, and snippets.

@carlosleopoldo

carlosleopoldo/delete-orphans-usermeta.sql

Last active June 16, 2023 13:23
Show Gist options
  • Star 37 You must be signed in to star a gist
  • Fork 14 You must be signed in to fork a gist
  • Save carlosleopoldo/5897807 to your computer and use it in GitHub Desktop.
Save carlosleopoldo/5897807 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
)
@zubaer-ahammed
Copy link

This is very useful. Thank you @carlosleopoldo

@KhalilAhmadDanish
Copy link

It was Great! worked for me.

@dragosstancu
Copy link

Bravo!

@dragosstancu
Copy link

Found a shorter one:

DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users);

@ahmadawais
Copy link

Deleted my admin user for some reason. Dev site so I'm safe.

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