I want to delete all records from wp_usermeta with user_id whose meta_value is "tonetone" which is spam accounts.

As you know already, there are many records with one user_id in wp_usermeta. I tried like this but doesn't work. Thanks to anyone who can show me the way.

delete from wp_usermeta where user_id = (select user_id from wp_usermeta where meta_value = "tonetone")

Just do:

delete from wp_usermeta where meta_value = "tonetone"

Don't you actually mean to delete the rows from wp_users, as opposed to just the metadata?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.