WP: Search and replace in DB programmatically

Is it possible to make a search-replace query on WP programmatically without any other plugins (I already know about “Better search replace” and other ones available, but it’s not the option).

Succinctly, yes – the existence of “Better Search and Replace” is a testament to the possibility.

A search-and-replace by itself is simple – you can make the necessary SQL queries through the WPDB interface. The complexity in writing such a thing from scratch lies in whether or not that operation needs to affect fields which WordPress serializes, as performing a replacement in serialized data without unserializing and reserializing the string or otherwise updating the serialization will invalidate the data.

If using a pre-made plugin is not an option, studying such a plugin’s code to see how they accomplish that feat would be a good move.

Related Posts:

  1. Post meta vs separate database tables
  2. Is it mandatory to use $wpdb->prefix in custom tables
  3. Update Option Stored in Multi-Dimensional Array
  4. Prevent network activation of plugin
  5. Uninstall script for a plugin in Multisite
  6. Changing Plugin Load Order
  7. Using a database view = evil incarnate?
  8. Writing a plugin that notify my friends of new post that mentions(@) them
  9. WordPress and multithreading
  10. What is the correct way for plugins to create tables with special charset/collation considerations?
  11. Error getting correct blog_id on MU from functions.php
  12. How is the data stored in the database?
  13. Actions or filters fired when data is saved in a custom table
  14. Multisite, sharing content by URL
  15. How to use wp_set_password in a plugin?
  16. WordPress Media mime type filter problem 4.0
  17. Sample — test — data for large WordPress install
  18. Is there any reason only 1 (my) IP would be added to this table using $wpdn->insert?
  19. How to store data for posts/pages built with drag-n-drop builder?
  20. What is the best way to overwrite /wp-admin/ms-delete-site.php
  21. Is there a naming convention for database tables created by a plugin?
  22. Where should I store global data for my multi-site WordPress plugin?
  23. unable to stop loop when using wp_insert_post with publish_post hook
  24. Plugin Uninstall and Deactivate via Options Menu
  25. how to activate plugin network-wide, and save setting across sites
  26. Saving data from block editor to the database
  27. What is difference between blog id and site id?
  28. Creating table with plugin is not working
  29. How to create a Tools menu on the Network Admin dashboard from a plugin
  30. dbDelta() Error – Incorrect index name ” for query ALTER TABLE
  31. Override the default Add/Edit site forms of the Network Panel in custom plugin
  32. Update/insert only a column of database table
  33. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  34. How to associate an existing user to a site in a multisite setup programmatically
  35. WordPress Multisite with Azure B2C redirect_urls after Login
  36. WordPress database error for query INSERT INTO
  37. How to connect to AWS RDS external database (not for the core WordPress db)
  38. How To Change Post Author Default?
  39. Adding (blog-specific) links to “My Sites” admin page
  40. Using WPDB to output raw XML fails because of wp-blog-header.php
  41. Strange issue saving custom field data for a WooCommerce order
  42. What should happen when a WordPress Plugin is activated across the network (Network Wide Activation)
  43. How to perform a heavy and long process in cron jobs?
  44. Form doesnt save to database
  45. Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
  46. Multiple Plugin best practice in Multisite
  47. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  48. Plugin Development for registered users
  49. Selectively update themes in WordPress multisite
  50. Problem with context in multisite – getting main site data in every blog (get_pages())
  51. Optimising a big WordPress site
  52. wpdb->prepare and mysql UPDATE – how is it done?
  53. dbDelta SQL Query Not Working
  54. register_activation_hook on multisite
  55. What is the best way to store a few fields?
  56. Plugin: database creation
  57. Delete data from database using row action
  58. Show dynamic list of products from custom api of another database under same host
  59. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  60. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  61. Make Database query only when option is updated
  62. WordPress multisite,use same cookies across all website?
  63. Can we intercept user_login and user_pass from a wp_login_form?
  64. How best to handle database version dependence (from $wp_db_version)
  65. Using AND and bracket grouping in SQL not working
  66. How to get current logged-in user details in multisite?
  67. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  68. add_action wp_ajax_ not loading in plugin file WP Network
  69. How do I debug an error that a plugin is causing?
  70. Save temporary registration data
  71. Update plugin settings option_name for big plugin update
  72. Is there anything special required to make a plugin work in a multisite environment?
  73. WordPress database error: [Query was empty] – using $wpdb->prepare()
  74. Why User_login key doesn’t work with wp_update_user()
  75. How to get inserted row IDs for bulk/batch insert with wpdb query?
  76. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  77. Replace “content-area” of themes 404 page with plugin?
  78. Save in my custom admin page and redirect to the saved object
  79. Relational / Associate tables using native WordPress functionality
  80. WordPress doesn’t create table on plugin activation
  81. Multisite and the JSON REST API: How to?
  82. Update database record in plugin
  83. How to store in the database directly the translation?
  84. Testing Plugins for Multisite
  85. How and when would I implement some code which would take data from one part of the Db and put it in another?
  86. Why Worpdress doesn’t create table in database?
  87. Form and database, plugin development
  88. Associating special meaning with user id 0
  89. What method should I use to store my plugin data (multi level menus with options on each item)
  90. How to add additional field in a table row after creating a table?
  91. WordPress plugin tables become corrupt
  92. Change Admin menu placement using hooks
  93. Force remove parent theme CSS/JS and call them from Child theme
  94. Running one-off cron jobs when WP_DISABLE_CRON is true: can I hit /wp-cron.php?
  95. Leveraging Core Functionality in Icon Upload Plugin [closed]
  96. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]
  97. multiple record insert creating many duplicate records
  98. 2 Domains pointing to SIngle WordPress , issues with links
  99. Custom database table entry edit page
  100. How to get list of ALL tables in the database?