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
)
@nuklearwintr
Copy link

Thanks, this is very useful

@carlosleopoldo
Copy link
Author

@nuklearwintr you're welcome

@MarceloPedra
Copy link

MarceloPedra commented Apr 25, 2016 •
edited

Excellent! It works with almost any WP version. Very thanks!

@EdisAganovic
Copy link

EdisAganovic commented Mar 31, 2017 •
edited

Thanks very much. Easy but get rid of 6000 rows of spam users. Works on 4.7.3.

@zoxee
Copy link

zoxee commented May 17, 2017

Excellent

@SteenSchutt
Copy link

Thanks - helped me get rid of 900k rows of usermeta after removing customers from a Woocommerce site for export 👍

@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