Quick Search Replace

Quick Search Replace provides a fast, modern, and user-friendly interface to run comprehensive search and replace operations on your WordPress database. Designed for site migrations, domain updates, and protocol switches (HTTP to HTTPS), it safely inspects every column of your selected tables.

It correctly handles serialized PHP data and JSON strings, protects composite primary key tables, and automatically flushes permalinks after a migration to prevent 404 errors.

Key Features:

• Modern Admin Interface: Redesigned dashboard with real-time table filtering, row count and table size metrics, and clean status indicators.
• Memory-Safe Chunked Processing: Queries tables in batches to prevent memory exhaustion and execution timeouts on large databases.
• Safe Serialized Data Handling: Automatically detects serialized arrays and objects, recursively substituting values and recalculating byte lengths without corrupting data.
• Dry Run with Visual Diff Preview: Test your search and replace query beforehand with sample before/after change snippets before modifying a single row.
• Smart URL & Domain Matching: Safely handles http/https, www, protocol-relative (//domain.com), and JSON-escaped URLs without altering unrelated words or slugs.
• Skip GUIDs Column Option: Follows official WordPress recommendations to preserve post GUIDs so RSS readers do not duplicate feed entries.
• Case-Insensitive Search Option: Toggle between exact-case and case-insensitive replacements with a single click.
• Composite Primary Key Support: Reliably updates complex relationship tables (such as wp_term_relationships) without accidental multi-row overwrites.
• WordPress Multisite Aware: Fully functional in both single-site and Network Admin environments, listing tables across the network.
• Automatic Permalink Flushing: Clears rewrite rules after a live run to ensure links work immediately.

WARNING: This tool directly modifies your database. While multiple safety checks and dry-run previews are built in, ALWAYS take a complete database backup before executing a live search and replace.