Using

wp search-replace <old> <new> [<table>...] [--dry-run] [--network] [--all-tables-with-prefix] [--all-tables] [--export[=<file>]] [--export_insert_size=<rows>] [--skip-tables=<tables>] [--skip-columns=<columns>] [--include-columns=<columns>] [--precise] [--recurse-objects] [--verbose] [--regex] [--regex-flags=<regex-flags>] [--regex-delimiter=<regex-delimiter>] [--regex-limit=<regex-limit>] [--format=<format>] [--report] [--report-changed-only] [--log[=<file>]] [--before_context=<num>] [--after_context=<num>]

<old>A string to search for within the database.<new>Replace instances of the first string with this new string.[<table>...]List of database tables to restrict the replacement to. Wildcards aresupported, e.g. `'wp_*options'` or `'wp_post*'`.[--dry-run]Run the entire search/replace operation and show report, but don't savechanges to the database.[--network]Search/replace through all the tables registered to $wpdb in amultisite install.[--all-tables-with-prefix]Enable replacement on any tables that match the table prefix even ifnot registered on $wpdb.[--all-tables]Enable replacement on ALL tables in the database, regardless of theprefix, and even if not registered on $wpdb. Overrides --networkand --all-tables-with-prefix.[--export[=<file>]]Write transformed data as SQL file instead of saving replacements tothe database. If <file> is not supplied, will output to STDOUT.[--export_insert_size=<rows>]Define number of rows in single INSERT statement when doing SQL export.You might want to change this depending on your database configuration(e.g. if you need to do fewer queries). Default: 50[--skip-tables=<tables>]Do not perform the replacement on specific tables. Use commas tospecify multiple tables. Wildcards are supported, e.g. `'wp_*options'` or `'wp_post*'`.[--skip-columns=<columns>]Do not perform the replacement on specific columns. Use commas tospecify multiple columns.[--include-columns=<columns>]Perform the replacement on specific columns. Use commas tospecify multiple columns.[--precise]Force the use of PHP (instead of SQL) which is more thorough,but slower.[--recurse-objects]Enable recursing into objects to replace strings. Defaults to true;pass --no-recurse-objects to disable.[--verbose]Prints rows to the console as they're updated.[--regex]Runs the search using a regular expression (without delimiters).Warning: search-replace will take about 15-20x longer when using --regex.[--regex-flags=<regex-flags>]Pass PCRE modifiers to regex search-replace (e.g. 'i' for case-insensitivity).[--regex-delimiter=<regex-delimiter>]The delimiter to use for the regex. It must be escaped if it appears in the search string. The default value is the result of `chr(1)`.[--regex-limit=<regex-limit>]The maximum possible replacements for the regex per row (or per unserialized data bit per row). Defaults to -1 (no limit).[--format=<format>]Render output in a particular format.---default: tableoptions:  - table  - count---[--report]Produce report. Defaults to true.[--report-changed-only]Report changed fields only. Defaults to false, unless logging, when it defaults to true.[--log[=<file>]]Log the items changed. If <file> is not supplied or is "-", will output to STDOUT.Warning: causes a significant slow down, similar or worse to enabling --precise or --regex.[--before_context=<num>]For logging, number of characters to display before the old match and the new replacement. Default 40. Ignored if not logging.[--after_context=<num>]For logging, number of characters to display after the old match and the new replacement. Default 40. Ignored if not logging.

# Search and replace but skip one column$ wp search-replace 'http://example.test' 'http://example.com' --skip-columns=guid# Run search/replace operation but dont save in database$ wp search-replace 'foo' 'bar' wp_posts wp_postmeta wp_terms --dry-run# Run case-insensitive regex search/replace operation (slow)$ wp search-replace '\[foo' '[bar' --regex --regex-flags='i'# Turn your production multisite database into a local dev database$ wp search-replace --url=example.com example.com example.test 'wp_*options' wp_blogs wp_site --network# Search/replace to a SQL file without transforming the database$ wp search-replace foo bar --export=database.sql# Bash script: Search/replace production to development url (multisite compatible)#!/bin/bashif $(wp --url=http://example.com core is-installed --network); then    wp search-replace --url=http://example.com 'http://example.com' 'http://example.test' --recurse-objects --network --skip-columns=guid --skip-tables=wp_userselse    wp search-replace 'http://example.com' 'http://example.test' --recurse-objects --skip-columns=guid --skip-tables=wp_usersfi

Installing

wp package install git@github.com:wp-cli/search-replace-command.git

Contributing

Reporting a bug

Creating a pull request

Support