[–dry-run]
Run the entire search/replace operation and show report, but don’t save changes to the database.

[–network]
Search/replace through all the tables registered to $wpdb in a multisite install.

[–all-tables-with-prefix]
Enable replacement on any tables that match the table prefix even if not registered on $wpdb.

[–all-tables]
Enable replacement on ALL tables in the database, regardless of the prefix, and even if not registered on $wpdb. Overrides –network and –all-tables-with-prefix.

[–export[=]]
Write transformed data as SQL file instead of saving replacements to the database. If is not supplied, will output to STDOUT.

[–export_insert_size=]
Define number of rows in single INSERT statement when doing SQL export. Default: 50

[–skip-tables=]
Do not perform the replacement on specific tables. Use commas to specify multiple tables. Wildcards supported.

[–skip-columns=]
Do not perform the replacement on specific columns. Use commas to specify multiple columns.

[–include-columns=]
Perform the replacement on specific columns. Use commas to specify 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=]
Pass PCRE modifiers to regex search-replace (e.g. ‘i’ for case-insensitivity).

[–regex-delimiter=]
The delimiter to use for the regex. Must be escaped if it appears in the search string. Default: chr(1).

[–regex-limit=]
The maximum possible replacements for the regex per row. Defaults to -1 (no limit).

[–format=]
Render output in a particular format.

• default: table
• options: 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[=]]
Log the items changed. If is not supplied or is "-", will output to STDOUT. Warning: causes significant slow down.

[–before_context=]
For logging, number of characters to display before the old match. Default 40.

[–after_context=]
For logging, number of characters to display after the old match. Default 40.

Examples

# 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 id="([0-9]+)"' '[bar id="1"' --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/bash
if $(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_users
else
    wp search-replace 'http://example.com' 'http://example.test' --recurse-objects --skip-columns=guid --skip-tables=wp_users
fi