• Skip to primary navigation
  • Skip to main content

RocketGeek

Home of WP-Members, The Original WordPress Membership Plugin

  • WordPress Plugins
    • WP-Members
      • FAQs
      • Quick Start
      • Documentation
      • Extensions
    • Advanced Options
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • Download Protect
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • Invite Codes
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • MailChimp Integration
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • PayPal Subscriptions
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • Salesforce Web-to-Lead
    • Security
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • Text Editor
      • Purchase the Plugin
      • Get the Pro Bundle
    • User List
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • User Tracking
      • Documentation
      • Purchase the Plugin
      • Get the Pro Bundle
    • Memberships for WooCommerce
    • WordPass
  • Blog
    • Basics
    • Tips and Tricks
    • Filters
    • Actions
    • Code Snippets
    • Shortcodes
    • Design
    • Release Announcements
  • Store
    • Cart
    • Checkout
  • Contact
  • Log In
  • Show Search
Hide Search
Home » Code Snippets » Remove wp_option values manually

Remove wp_option values manually

Chad Butler · Apr 26, 2026 ·

# Set of MySQL queries to remove any and all WP-Members database
# entries from the WordPress database. This should only be used
# for a complete and total removal where a clean start is needed
# as it removes not only settings but also any WP-Members-specific
# user and post data.

DELETE FROM wp_options WHERE option_name = "wpmembers_optin";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_settings"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_fields";   # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_dialogs";  # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_captcha";  # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_tos";      # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_export";   # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_dropins";  # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_hidden_posts"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_memberships";  # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_utfields"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_usfields"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_wcchkout_fields"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_wcupdate_fields"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_wcacct_fields";   # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_newreg";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_newmod";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_appmod";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_repass";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_footer";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_notify";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_wpfrom";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_wpname";    # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_html";      # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_getuser";   # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_email_validated"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "widget_widget_wpmemwidget"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "widget_wpmemwidget";        # Removed by uninstalll
DELETE FROM wp_options WHERE option_name = "wpmembers_install_state";   # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_enable_field_sc";     # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_dismiss_filesystem_upgrade_notice"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_upgrade_filesystem_move_complete";  # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_msurl";  # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_regurl"; # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_logurl"; # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_cssurl"; # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_style";  # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_autoex"; # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmembers_attrib"; # Legacy value pre 3.x, Removed by uninstall
DELETE FROM wp_options WHERE option_name = "wpmem_legacy_dialogs";
DELETE FROM wp_options WHERE option_name = "_transient_wpmem_user_counts"; # Removed by uninstall
DELETE FROM wp_options WHERE option_name = "_transient_timeout_wpmem_user_counts";
DELETE FROM wp_options WHERE option_name = "_transient__wpmem_hidden_posts";
DELETE FROM wp_options WHERE option_name = "_transient_timeout__wpmem_hidden_posts";

Not sure what to do with this code?

You're not a "coder" and don't know what to do? Don't worry! Code Snippets are the basic building blocks of WordPress customization, and once you know the basics, they are simple to use.

Here are some free articles to get you started:

  • Using Code Snippets from the Site
  • Using a code snippets plugin
  • The functions.php File
  • Create a plugin file for custom functions
  • Create a child theme
  • Do not modify plugin files!

For "hands on" help, consider a plugin support subscription or the Pro Bundle.

Ready to get started?

Join Today!

© 2026 · butlerblog.com · RocketGeek is built using WordPress, WP-Members, and the Genesis Framework

  • butlerblog.com
  • WP-Members Support Subscription
  • Terms of Service
  • Privacy Policy
  • Refund Policy