A command line interface for WordPress

wp search-replace - Search/replace strings in the database.

Quick links: Github issues


This command will searches through all rows in a selection of tables and replaces appearances of the first string with the second string.

By default, the command uses tables registered to the $wpdb object. On multisite, this will just be the tables for the current site unless --network is specified.

Search/replace intelligently handles PHP serialized data, and does not change primary key values.


A string to search for within the database.
Replace instances of the first string with this new string.
List of database tables to restrict the replacement to. Wildcards are supported, e.g. 'wp_*_options' or 'wp_post*'.
Run the entire search/replace operation and show report, but don’t save changes to the database.
Search/replace through all the tables registered to $wpdb in a multisite install.
Enable replacement on any tables that match the table prefix even if not registered on $wpdb.
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.
Write transformed data as SQL file instead of saving replacements to the database. If <file> is not supplied, will output to STDOUT.
Do not perform the replacement on specific columns. Use commas to specify multiple columns. ‘guid’ is skipped by default.
Force the use of PHP (instead of SQL) which is more thorough, but slower.
Enable recursing into objects to replace strings. Defaults to true; pass –no-recurse-objects to disable.
Prints rows to the console as they’re updated.
Runs the search using a regular expression. Warning: search-replace will take about 15-20x longer when using –regex.


wp search-replace 'http://example.dev' 'http://example.com' --skip-columns=guid

wp search-replace 'foo' 'bar' wp_posts wp_postmeta wp_terms --dry-run

# Turn your production multisite database into a local dev database
wp search-replace --url=example.com example.com example.dev 'wp_*_options' wp_blogs

# Search/replace to a SQL file without transforming the database
wp search-replace foo bar --export=database.sql