WordPress: How to Selectively Remove Users’ wp_usermeta Data with SQL Command

DELETE FROM wp_usermeta WHERE user_id NOT IN(SELECT ID FROM wp_users WHERE user_login IN ('admin','second_user_to_keep','etc'))

Related Posts

One response to “WordPress: How to Selectively Remove Users’ wp_usermeta Data with SQL Command”

  1. Air Covererd Yarn Avatar

    Yes this is very easy way to delete a user. Everyone must be known to delete user by command instead delete by using database.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.