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 *

Get in touch

Contact me using the details below

Marinus Klasen

Wilhelmina van Pruisenweg 35, 2595 AN Den Haag

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

  • GitHub
  • LinkedIn
  • Twitter

Have you read?

  • Disable the ‘Password Changed’ Email notification in WordPress with a filterAugust 30, 2023
  • A-Frame: Change an objects color on hoverAugust 24, 2023
  • Connecting to a Cloudways application with VSCodeAugust 15, 2023
  • Force refresh PHP-FPM or Litespeed cacheAugust 4, 2023
  • Only return zip/postal codes from Google Places AutoComplete Javascript APIJuly 19, 2023

Copyright © 2023 · Marinus Klasen | Webdesign by Team Rood