{"id":240723,"date":"2025-08-13T18:18:59","date_gmt":"2025-08-13T18:18:59","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/awesome-search-replace\/"},"modified":"2026-02-02T20:03:09","modified_gmt":"2026-02-02T20:03:09","slug":"sigma-search-replace","status":"publish","type":"plugin","link":"https:\/\/pcd.wordpress.org\/plugins\/sigma-search-replace\/","author":14587731,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.0","stable_tag":"1.0.0","tested":"6.9.4","requires":"5.0","requires_php":"7.0","requires_plugins":null,"header_name":"Sigma Search & Replace","header_author":"Younes JFR.","header_description":"The ultimate search & replace plugin for WordPress. Safely update text, URLs, and serialized data across your entire database.","assets_banners_color":"599bd7","last_updated":"2026-02-02 20:03:09","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.sigmaplugin.com\/donation","header_plugin_uri":"","header_author_uri":"https:\/\/sigmaplugin.com","rating":5,"author_block_rating":0,"active_installs":40,"downloads":503,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"symptote","date":"2026-02-02 20:03:09"}},"upgrade_notice":{"1.0.0":"<p>First public version. Back up your database before use.<\/p>\n\n<p><strong>Important<\/strong>: Always backup your database before using any search and replace tool. While this plugin includes safety features, database operations can be irreversible.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3344137,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3344137,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3344137,"resolution":"1544x500","location":"assets","locale":""},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3344137,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3344137,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3344137,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3344137,"resolution":"3","location":"assets","locale":""},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3344137,"resolution":"4","location":"assets","locale":""},"screenshot-5.png":{"filename":"screenshot-5.png","revision":3344137,"resolution":"5","location":"assets","locale":""},"screenshot-6.png":{"filename":"screenshot-6.png","revision":3344137,"resolution":"6","location":"assets","locale":""},"screenshot-7.png":{"filename":"screenshot-7.png","revision":3344137,"resolution":"7","location":"assets","locale":""},"screenshot-8.png":{"filename":"screenshot-8.png","revision":3344137,"resolution":"8","location":"assets","locale":""}},"screenshots":{"1":"Main search and replace interface with form inputs","2":"Table selection screen showing database tables","3":"Search progress with real-time updates","4":"Detailed search results before replacement","5":"Preview the changes in each table, broken down by rows and cells","6":"Replacement progress tracking","7":"Settings page with configuration options","8":"System information and logs page"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[3921,7854,944,246277,12126],"plugin_category":[],"plugin_contributors":[246278,79745],"plugin_business_model":[],"class_list":["post-240723","plugin","type-plugin","status-publish","hentry","plugin_tags-find","plugin_tags-replace","plugin_tags-search","plugin_tags-search-database","plugin_tags-search-replace","plugin_contributors-issamox2008","plugin_contributors-symptote","plugin_committers-symptote"],"banners":{"banner":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/banner-772x250.png?rev=3344137","banner_2x":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/banner-1544x500.png?rev=3344137","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/icon-128x128.png?rev=3344137","icon_2x":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/icon-256x256.png?rev=3344137","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-1.png?rev=3344137","caption":"Main search and replace interface with form inputs"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-2.png?rev=3344137","caption":"Table selection screen showing database tables"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-3.png?rev=3344137","caption":"Search progress with real-time updates"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-4.png?rev=3344137","caption":"Detailed search results before replacement"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-5.png?rev=3344137","caption":"Preview the changes in each table, broken down by rows and cells"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-6.png?rev=3344137","caption":"Replacement progress tracking"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-7.png?rev=3344137","caption":"Settings page with configuration options"},{"src":"https:\/\/ps.w.org\/sigma-search-replace\/assets\/screenshot-8.png?rev=3344137","caption":"System information and logs page"}],"raw_content":"<!--section=description-->\n<p><strong>Sigma Search &amp; Replace<\/strong> is a comprehensive WordPress plugin that allows you to search and replace content throughout your WordPress database with ease and safety. Whether you're migrating a site, changing domain names, or updating content across multiple posts, this plugin provides a user-friendly interface to handle complex database operations.<\/p>\n\n<h4>How It Works<\/h4>\n\n<ol>\n<li><strong>Search Phase<\/strong> - The plugin searches through your database tables to find matches<\/li>\n<li><strong>Review Results<\/strong> - View detailed reports of what will be changed before proceeding<\/li>\n<li><strong>Replace Phase<\/strong> - Safely execute the replacement with progress tracking<\/li>\n<li><strong>Completion Report<\/strong> - Get a detailed summary of all changes made<\/li>\n<\/ol>\n\n<h4>Key Features<\/h4>\n\n<ul>\n<li><strong>Selective Table Processing<\/strong> - Choose which tables to include in operations<\/li>\n<li><strong>Two-Step Safety<\/strong> \u2013 <em>Search<\/em> \u2192 review \u2192 <em>Replace<\/em>; nothing changes until you click replace. <\/li>\n<li><strong>Case Sensitive\/Insensitive Search<\/strong> - Full control over search sensitivity<\/li>\n<li><strong>GUID Protection<\/strong> - Option to skip WordPress GUIDs to maintain data integrity<\/li>\n<li><strong>Serialized-Data Support<\/strong> \u2013 Detect and update strings stored inside PHP-serialized arrays or objects without breaking their structure.<\/li>\n<li><strong>Real-time Search Progress<\/strong> - Live progress tracking with detailed reporting; click Stop to cancel mid-run.<\/li>\n<li><strong>Real-time Replace Progress<\/strong> - Live progress tracking with detailed reporting; click Stop to cancel mid-run.<\/li>\n<li><strong>Batch Processing<\/strong> - Handles large databases efficiently with configurable batch sizes<\/li>\n<li><strong>Detailed Search Preview<\/strong> - Comprehensive user-friendly interface showing exactly what was found and changed<\/li>\n<li><strong>Detailed Reports &amp; Logs<\/strong> \u2013 Per-table hit counts, replacement summaries, and error logs.  <\/li>\n<li><strong>Multisite Ready<\/strong> \u2013 Network admin: any site; sub-site admin: own site only.<\/li>\n<li><strong>Modern React Interface<\/strong> - Clean, intuitive user interface built with React<\/li>\n<li><strong>REST API Integration<\/strong> - Secure API endpoints for all operations<\/li>\n<\/ul>\n\n<h4>Perfect For<\/h4>\n\n<ul>\n<li><strong>Site Migration<\/strong> - Moving WordPress sites to new domains or servers<\/li>\n<li><strong>URL Updates<\/strong> - Changing domain names or switching between HTTP\/HTTPS<\/li>\n<li><strong>Content Updates<\/strong> - Bulk updating text, links, or other content across your site<\/li>\n<li><strong>Development<\/strong> - Updating staging site URLs for local development<\/li>\n<li><strong>Maintenance<\/strong> - Cleaning up old content or updating deprecated information<\/li>\n<\/ul>\n\n<h4>Safety Features<\/h4>\n\n<ul>\n<li><strong>Backup Warnings<\/strong> - Multiple reminders to backup your database before making changes<\/li>\n<li><strong>Dry Run Capability<\/strong> - Preview what will be changed without making actual modifications<\/li>\n<li><strong>Table Validation<\/strong> - Ensures database tables are valid before processing<\/li>\n<li><strong>Smart Change Detection<\/strong> - Skips updates if values changed after the search.<\/li>\n<li><strong>Site URL Safeguard<\/strong> - Automatically detect and delay site URL edits to the end to avoid breaking the process.<\/li>\n<li><strong>Error Handling<\/strong> - Comprehensive error handling and logging<\/li>\n<\/ul>\n\n<h4>Technical Features<\/h4>\n\n<ul>\n<li><strong>Efficient Processing<\/strong> - Handles large databases with memory-conscious batch processing<\/li>\n<li><strong>Timeout Management<\/strong> - Automatic timeout handling for long-running operations<\/li>\n<li><strong>Security<\/strong> - Proper authentication and authorization checks<\/li>\n<li><strong>Logging<\/strong> - Comprehensive logging system for troubleshooting<\/li>\n<\/ul>\n\n<!--section=installation-->\n<p>This section describes how to install the plugin. In general, there are 3 ways to install this plugin like any other WordPress plugin.<\/p>\n\n<h4>1. Via WordPress dashboard<\/h4>\n\n<ul>\n<li>Click on 'Add New' in the plugins dashboard<\/li>\n<li>Search for 'sigma-search-replace'<\/li>\n<li>Click 'Install Now' button<\/li>\n<li>Activate the plugin from the same page or from the Plugins dashboard<\/li>\n<\/ul>\n\n<h4>2. Via uploading the plugin to WordPress dashboard<\/h4>\n\n<ul>\n<li>Download the plugin to your computer from (https:\/\/wordpress.org\/plugins\/sigma-search-replace\/)<\/li>\n<li>Click on 'Add New' in the plugins dashboard<\/li>\n<li>Click on 'Upload Plugin' button<\/li>\n<li>Select the zip file of the plugin that you have downloaded to your computer before<\/li>\n<li>Click 'Install Now'<\/li>\n<li>Activate the plugin from the Plugins dashboard<\/li>\n<\/ul>\n\n<h4>3. Via FTP<\/h4>\n\n<ul>\n<li>Download the plugin to your computer from (https:\/\/wordpress.org\/plugins\/sigma-search-replace\/)<\/li>\n<li>Unzip the zip file, which will extract the 'sigma-search-replace-x.x.x' directory<\/li>\n<li>Upload the 'sigma-search-replace' directory (included inside the extracted folder) to the \/wp-content\/plugins\/ directory in your web space <\/li>\n<li>Activate the plugin from the Plugins dashboard<\/li>\n<\/ul>\n\n<h4>For Multisite installation<\/h4>\n\n<ul>\n<li>Log in to your primary site and go to \"My Sites\" &raquo; \"Network Admin\" &raquo; \"Plugins\"<\/li>\n<li>Install the plugin following one of the above ways<\/li>\n<li>Network activate the plugin (Note that the main site will search\/replace in the whole network tables, single sites will only have access to their tables)<\/li>\n<\/ul>\n\n<h4>Where the plugin menu will be displayed?<\/h4>\n\n<ul>\n<li>The plugin page can be accessed via \"Dashboard\" &raquo; \"Tools\" &raquo; \"SSR Replace\" or via the left menu \"SSR Replace\" or via the network dashboard for multisite \"SSR Replace\" (You can change this via the plugin settings)<\/li>\n<\/ul>\n\n<!--section=faq-->\n<dl>\n<dt id=\"can%20i%20search%20specific%20database%20tables%20only%3F\"><h3>Can I search specific database tables only?<\/h3><\/dt>\n<dd><p>Yes, you can select which database tables to include in your search and replace operations.<\/p><\/dd>\n<dt id=\"is%20it%20safe%20to%20use%20this%20plugin%3F\"><h3>Is it safe to use this plugin?<\/h3><\/dt>\n<dd><p>Yes, when used properly. The plugin includes multiple safety features and warnings, but you should <strong>always backup your database<\/strong> before performing any search and replace operations. The plugin will remind you to do this.<\/p><\/dd>\n<dt id=\"will%20it%20break%20serialized%20data%3F\"><h3>Will it break serialized data?<\/h3><\/dt>\n<dd><p>No. The plugin unserializes, replaces, then re-serializes values so data remains valid.<\/p><\/dd>\n<dt id=\"can%20i%20undo%20changes%20made%20by%20the%20plugin%3F\"><h3>Can I undo changes made by the plugin?<\/h3><\/dt>\n<dd><p>The plugin doesn't have a built-in undo feature, which is why backing up your database beforehand is crucial. The detailed reports can help you understand what was changed.<\/p><\/dd>\n<dt id=\"does%20it%20work%20with%20multisite%20installations%3F\"><h3>Does it work with multisite installations?<\/h3><\/dt>\n<dd><p>Yes. Network admins can target any site tables; sub-site admins are limited to their own tables.<\/p><\/dd>\n<dt id=\"will%20it%20work%20with%20large%20databases%3F\"><h3>Will it work with large databases?<\/h3><\/dt>\n<dd><p>Yes, the plugin is optimized for large databases using batch processing and memory-efficient techniques. However, performance depends on your hosting resources. In some cases (especially on low-memory or shared environments) it may not be possible to complete the process reliably.<\/p><\/dd>\n<dt id=\"what%20happens%20if%20the%20process%20times%20out%3F\"><h3>What happens if the process times out?<\/h3><\/dt>\n<dd><p>The plugin has built-in timeout management in the search phase and can automatically resume where it left off.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.0 - 13\/08\/2025<\/h4>\n\n<ul>\n<li>Initial release: let's search the world!<\/li>\n<\/ul>","raw_excerpt":"The ultimate search &amp; replace plugin for WordPress. Safely update text, URLs, and serialized data across your entire database with confidence.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/240723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=240723"}],"author":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/symptote"}],"wp:attachment":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=240723"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=240723"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=240723"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=240723"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=240723"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=240723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}