Search and Replace Across Selected Tables (PRO)

PRO mode lets you run search/replace on selected database tables, not just predefined content areas.

Why Use This

  • Target only specific tables
  • Include custom plugin/theme tables
  • Reduce risk by avoiding unrelated tables

Main Options

  • Search For: Old URL/text
  • Replace With: New URL/text
  • Select Tables: Multi-select table picker with filter
  • Case-Insensitive: Optional
  • Replace GUIDs: Optional
  • Run as dry run: Recommended first step

Steps

  1. Open WordPress Admin > Update URLS > Search / Replace.
  2. Enter search and replace values.
  3. Select one or more tables in Tables to Include.
  4. Configure additional settings.
  5. Click Run Search/Replace.

Result Behavior

  • Progress is shown in a modal with table-by-table updates.
  • After completion, you get a summary and a details view.
  • Non-dry-run operations are stored in History automatically.

Best Practice

  • Start with wp_posts, wp_postmeta, and wp_options (or your prefixed equivalents).
  • Add custom tables only when needed.

Was this page helpful?