Skip to content

Instantly share code, notes, and snippets.

@webaware
Last active August 5, 2022 10:41
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save webaware/d1b51f68977d32603491 to your computer and use it in GitHub Desktop.
Save webaware/d1b51f68977d32603491 to your computer and use it in GitHub Desktop.
Clean up the mess left in WordPress users tables by WP e-Commerce, after you've removed that plugin from WordPress.
delete from u, um
using wp_users u
left join wp_usermeta um on um.user_id = u.ID
where u.user_login like '\_%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment