Skip to content

Instantly share code, notes, and snippets.

@mkormendy
Forked from webaware/gist:d1b51f68977d32603491
Last active August 29, 2015 14:26
Show Gist options
  • Save mkormendy/25d5fc53c6b034afe29f to your computer and use it in GitHub Desktop.
Save mkormendy/25d5fc53c6b034afe29f 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