wp option list

Lists options and their values.

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 FIELDS

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.

GLOBAL PARAMETERS

These global parameters have the same behavior across all commands and affect how WP-CLI interacts with WordPress.