search replace command
2.1.7
搜索/替换数据库中的字符串。
快速链接：使用 |安装 |贡献 |支持
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>]
搜索选定表中的所有行，并用第二个字符串替换第一个字符串的出现。
默认情况下，该命令使用注册到$wpdb对象的表。在多站点上，除非指定--network ，否则这只是当前站点的表。
搜索/替换智能处理 PHP 序列化数据，并且不更改主键值。
选项
<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 are supported, e.g. `'wp_*options'` or `'wp_post*'`. [--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[=<file>]] Write transformed data as SQL file instead of saving replacements to the 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 to specify 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 to specify multiple columns. [--include-columns=<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=<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: 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[=<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 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
该软件包包含在 WP-CLI 本身中，无需额外安装。
要通过 WP-CLI 中包含的内容安装此软件包的最新版本，请运行：
wp package install [email protected]:wp-cli/search-replace-command.git
我们感谢您主动为该项目做出贡献。
贡献不仅仅限于代码。我们鼓励您以最适合您能力的方式做出贡献，例如编写教程、在本地聚会上进行演示、帮助其他用户解决支持问题或修改我们的文档。
有关更全面的介绍，请查看 WP-CLI 的贡献指南。该软件包遵循这些政策和准则。
您认为您发现了错误吗？我们希望您能帮助我们解决问题。
在创建新问题之前，您应该搜索现有问题以查看是否有现有解决方案，或者是否已在新版本中修复。
一旦您完成一些搜索并发现您的错误没有未解决或已修复的问题，请创建一个新问题。包含尽可能多的细节，并在可能的情况下明确重现的步骤。如需更多指导，请查看我们的错误报告文档。
想贡献一个新功能吗？请首先打开一个新问题来讨论该功能是否适合该项目。
一旦您决定花时间查看您的拉取请求，请遵循我们的创建拉取请求指南，以确保这是一次愉快的体验。有关在本地处理此包的详细信息，请参阅“设置”。
GitHub 问题不适用于一般支持问题，但您可以尝试其他场所：https://wp-cli.org/#support
此 README.md 是使用wp scaffold package-readme (doc) 从项目的代码库动态生成的。要提出更改建议，请针对代码库的相应部分提交拉取请求。
