Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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")
share|improve this question

1 Answer 1

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?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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