how to update serialized options programatically?

WP-CLI is definitely the answer to this after the update to 1.4.0 which introduced the pluck and patch commands for accessing serialized data in WordPress.

The pluck command takes this format for grabbing serialized values

wp option pluck <key> <key-name>

For example in the active_plugins option you can grab first item

wp option pluck active_plugins 0

The patch command takes this format for inserting, updating or removing serialized values (the action)

wp option patch <action> <key> <key-name> <value>

Deleting the first active_plugin would look like this

wp option patch delete active_plugins 0

The same pluck and patch were also added for other commands like postmeta, you can now use WP-CLI to do some cool loops for updating WordPress serialized data programmatically

Related Posts:

  1. How to update an ‘array’ option using wp-cli [duplicate]
  2. Are transients garbage collected?
  3. Are all options loaded to memory on each request?
  4. How to pass variable to add_settings_section() callback?
  5. Using widget options ‘outside’ the widget
  6. How to load WordPress on non WP page?
  7. Options for CDN with WordPress Including Supporting Plugins?
  8. Option to set static front page disappeared from admin reading settings
  9. How to set up default values for a plugin?
  10. Difference between Option_Group and Option_Name in Register_Settings
  11. Plugin options autoloading
  12. Settings API – creating reusable form elements?
  13. Efficient way of saving plugin options
  14. Setting ‘autoload’ to ‘no’ with Settings API
  15. Why isn’t get_option array contents displaying?
  16. How to Save Different Settings Options Using Settings API and/or the Theme Optimizer
  17. Define WordPress image size in img tag
  18. Editor role not saving settings page for custom post type
  19. get_option() is not working even db contains the corresponding option_name and option_value
  20. Proper use of option_page_capability_{$page_name}
  21. Which WordPress option stores the current active theme?
  22. update_option method with support of utf8
  23. How to save WordPress Options as an array?
  24. update_option not working in stand-alone PHP script
  25. How to verify this checkbox is checked?
  26. Best practice differences in DB options and wp-config between live, staging and local WordPress environments?
  27. Logout redirects to a broken page(home URL is omitted)
  28. What to use , set_transient, set_option or file system? [closed]
  29. Settings API get_option best practices
  30. Custom theme options Radio inputs not saving
  31. Character Encoding for wp_options
  32. Clone plugins (and settings) to new installation?
  33. display all posts in wordpress admin crashing after 999 screen option
  34. Allow spiders to crawl my site (selectable option in wp)
  35. Putting my site live
  36. Add an option to a Child theme of Twenty Eleven
  37. The Settings API – What is the purpose of default value in register_setting?
  38. settings_fields doesn’t appear to be running
  39. How to store a value on WP_option table
  40. Changing the language in Site Language does nothing
  41. Two settings_fields in one form
  42. Custom blog settings
  43. Run function on settings save
  44. wp_usermeta wp_usersettings
  45. How to set wp_editor to be email friendly?
  46. How to change user admin_color with WP CLI?
  47. Work flow for multiple developers
  48. i changed my wordpress address url in SETTINGS – GENRERAL – wordpress address site url. cannot login anymore
  49. update object options on option form
  50. Functions to edit wp-config.php [duplicate]
  51. Transients API conditional
  52. How to use a newly registered setting with a checkbox and the default value ‘true’
  53. help using get_option
  54. Settings API validation callback
  55. How to check False booleans when using get_option?
  56. Different Front page for Mobile
  57. Is there any other place – besides a theme, a plugin, or a mu-plugin – that an option page might conceivably be used?
  58. How to save user meta on custom admin page
  59. Is there an optimized, WordPress-y way to not call a `get_option` twice?
  60. get_option and list of options
  61. Verify Values Using Settings API
  62. Which Hook can I use when creating unique post but not update/save/delete
  63. How to use update_option() without replacing/losing the old value?
  64. Automate WordPress website setup with prefilled data
  65. Settings API and ‘type’ => ‘font’
  66. Create a counter variable in wp_options that increments when submit button is pressed
  67. Assigning a Setting to a Variable and Using it in an if Statement
  68. Options page: values don’t show up in dashboard
  69. WordPress Settings API settings not saving for some users
  70. Sharing Buttons not Working – Sharing Settings [closed]
  71. Character \ appearing before ‘ after saving a settings page
  72. Theme Option select values
  73. How to add a Reset to Defaults button with Settings API?
  74. Settings API no update status? (refering to the yellow bar when you save settings)
  75. PHP class to add pages and fields in admin panel
  76. get_option() and update_option() in a transaction (for an autoincrement value)
  77. How to change color of a word in text after WP update
  78. display category name based on its equivalent id
  79. Option value not get saved in the database
  80. Is it possible to have a global parameter page which allows to configure other plugins in the same place?
  81. Help to create the best plugin settings!
  82. Encoding matter – ? instead of € after settings field callback
  83. Problem with checkbox in Settings API
  84. add image in dropdown select
  85. Repeatable option fields not saving
  86. Settings API retrieving options database information alongside with user information?
  87. Dynamically Update Key in Associative Array When Saving Settings
  88. Incorporating the Settings API in WordPress Themes – by Chip Bennet
  89. Option does not save or update upon page refresh
  90. WordPress options text format
  91. Caching of SQL queries
  92. WordPress theme options tabs
  93. Importing WP settings to another host
  94. Only show theme option if it option exists
  95. The issue of redirecting my site to a new domain
  96. Custom general settings (textarea field) don’t output HTML correctly
  97. Using get_option() for check box field
  98. Where to adjust presets for slider options “auto rotate” (3, 5, 10, 15 seconds)? [closed]
  99. change backend header options
  100. If Home Page Do Nothing, If All Else Show This Content

Leave a Comment