Marinus Klasen

Marinus Klasen

  • Development
  • Consultancy
  • Developer Resources
  • Blog
  • Contact

October 28, 2021

Bulk deleting options in WordPress database

Marinus Klasen

Since I wanted to test how my plugin would function without data, I needed to clear some ACF created options from the database. ACF creates a whole bunch of options using a very similar name, in my case;

  • options_mc_creator_mailchimp_api_key
  • _options_mc_creator_mailchimp_api_key
  • options_mc_creator_mailchimp_server
  • And lots more..

I like using WP CLI for this but WP CLI doesn’t allow me to delete options by search. We can solve that though.

WP CLI allows searching for options

We can use this: wp option list --search='options_mc_creator'

Now, we just want the option_name:
wp option list --fields='option_name' --search 'options_mc_creator'

And then get rid of the formatting by formatting as CSV:
wp option list --fields='option_name' --search='options_mc_creator' --format=csv

Let’s feed the output of that command to the delete function:

wp option delete $(wp option list --fields='option_name' --search='options_mc_creator' --format=csv)

Boom! all done.

About Marinus Klasen

Marinus has been working in software/web development for more than a decade. Since 2020 his attention shifted on sharing knowledge and developing products and tools for sharing knowledge.

Marinus Klasen on Twitter

This site runs on Cloudways.
It's fast isn't it?
Cloudways offers high-quality, fast and affordable hosting.

Learn more

Need a hand? Post your project and hire me and other top notch developers on Codeable.

Hire me on Codeable

Leave a Reply Cancel reply

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

Ready to take action?

I'm looking forward to discuss your projects and goals!
Feel free to reach out using the contact details below.

Marinus Klasen

[email protected]
twitter.com/marinusklasen
linkedin.com/in/marinusklasen

  • GitHub
  • LinkedIn
  • Twitter

Have you read?

  • Storing private data with SSH on WPEngine sitesDecember 15, 2022
  • Get the HTML content of a block edit page or post in WordPressNovember 30, 2022
  • Rename Coupon code text to Discount code in WoocommerceNovember 3, 2022
  • Background-size cover in mPDFOctober 22, 2022
  • WordPress.com SSH & duplicating a WordPress.com website locallyOctober 11, 2022

Copyright © 2023 · Marinus Klasen | Webdesign by Team Rood