WP CLIThe command line interface for WordPress

wp option list

Lists options and their values.

wp option list [--search=<pattern>] [--exclude=<pattern>] [--autoload=<value>] [--transients] [--unserialize] [--field=<field>] [--fields=<fields>] [--format=<format>] [--orderby=<fields>] [--order=<order>]

Options

[--search=<pattern>]

Use wildcards ( * and ? ) to match option name.

[--exclude=<pattern>]

Pattern to exclude. Use wildcards ( * and ? ) to match option name.

[--autoload=<value>]

Match only autoload options when value is on, and only not-autoload option when off.

[--transients]

List only transients. Use --no-transients to ignore all transients.

[--unserialize]

Unserialize option values in output.

[--field=<field>]

Prints the value of a single field.

[--fields=<fields>]

Limit the output to specific object fields.

[--format=<format>]

The serialization format for the value. total_bytes displays the total size of matching options in bytes. [Default: table]

Options:
  • table
  • json
  • csv
  • count
  • yaml
  • total_bytes

[--orderby=<fields>]

Set orderby which field. [Default: option_id]

Options:
  • option_id
  • option_name
  • option_value

[--order=<order>]

Set ascending or descending order. [Default: asc]

Options:
  • asc
  • desc

Available Options

This field will be displayed by default for each matching option:

  • option_name
  • option_value

These fields are optionally available:

  • autoload
  • size_bytes

Examples

# Get the total size of all autoload options. $ wp option list --autoload=on --format=total_bytes 33198 # Find biggest transients. $ wp option list --search="*_transient_*" --fields=option_name,size_bytes | sort -n -k 2 | tail option_name size_bytes _site_transient_timeout_theme_roots 10 _site_transient_theme_roots 76 _site_transient_update_themes 181 _site_transient_update_core 808 _site_transient_update_plugins 6645 # List all options beginning with "i2f_". $ wp option list --search="i2f_*" +-------------+--------------+ | option_name | option_value | +-------------+--------------+ | i2f_version | 0.1.0 | +-------------+--------------+ # Delete all options beginning with "theme_mods_". $ wp option list --search="theme_mods_*" --field=option_name | xargs -I % wp option delete % Success: Deleted 'theme_mods_twentysixteen' option. Success: Deleted 'theme_mods_twentyfifteen' option. Success: Deleted 'theme_mods_twentyfourteen' option.

Related Commands