DE

↑ ↓ select, Enter open, Esc close

Find posts with a specific meta key

harmlessWP-CLIalle
Adjust the values, the command updates live
user@server
wp post list --post_type=any --meta_key=_yoast_wpseo_meta-robots-noindex --fields=ID,post_type,post_title --path=/var/www/vhosts/example.com/httpdocs

Finds all published content of every post type where the given meta field is set. The default value finds pages that were individually set to noindex in Yoast SEO. Add --meta_value=1 to also filter by value.

Note: Without --post_status, only published content is included. wp post meta get <ID> <key> shows the value of a field.

Also searched as

  • which pages use a custom field
  • find noindex pages wordpress
  • search post meta wp cli

Related one-liners

All in WP-CLI

Count WordPress posts by status

$wp post list --post_type=post --post_status=any --field=post_status --path=/var/www/vhosts/example.com/httpdocs | sort | uniq -c
harmlessWP-CLI

Back up the WordPress database as a gzip file

$wp db export - --path=/var/www/vhosts/example.com/httpdocs | gzip > /var/www/vhosts/example.com/db-backup.sql.gz
harmlessWP-CLI

Change domain: replace the old domain in the database

$wp db export /var/www/vhosts/example.com/before-domain-change.sql --path=/var/www/vhosts/example.com/httpdocs && wp search-replace '//old.example.com' '//example.com' --all-tables --skip-columns=guid --path=/var/www/vhosts/example.com/httpdocs
destructiveWP-CLI

Change the role of a WordPress user

$wp user set-role editorial editor --path=/var/www/vhosts/example.com/httpdocs
cautionWP-CLI

Change the siteurl and home addresses

$wp option update siteurl 'https://example.com' --path=/var/www/vhosts/example.com/httpdocs && wp option update home 'https://example.com' --path=/var/www/vhosts/example.com/httpdocs
cautionWP-CLI

Check whether WordPress blocks search engines

$wp option get blog_public --path=/var/www/vhosts/example.com/httpdocs
harmlessWP-CLI

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.