Add or overwrite WordPress Options (wp_options)
gathering interest
C
Christian L.
A possibility to add or overwrite WP Options in the wp_options table.
It is not that easy or nearly impossible to search and replace settings within (plugin) options because they are stored as serialised objects or arrays that get unserialised during the search and replace process of WP Migrate. So setting an 'on' to 'off' is not possible because it will replace things globally.
Here I suggest a static overwriting of the complete value (or inserting when the entry does not exist). But it would be also a nice feature when you could do a search and replace within a option_value focused on one option_name.
C
Christian L.
Kevin Hoffman I would say that most changes need to be done in the
wp_options
table. The UI/UX for that table wold be much easier than the UI for general table changes where one would need a selector/text field for the table, for the field that should identify the row and the condition (the WHERE statement). It would be great to have a possibility to change
wp_options
first. And if it's easy to implement a feature to change every table without delaying the release of the main requirement - brilliant, go for it. :-)
Kevin Hoffman
Christian L.: That makes sense! Making it possible for any table would certainly increase the scope and complexity of the UI.
Kevin Hoffman
gathering interest
Kevin Hoffman
Christian L. Thanks for detailing this feedback. Do you ever find a need for this functionality in other tables besides the
wp_options
table?