This script prompts the user to enter a postmeta key to search for, and then retrieves the value of that postmeta key for each post on your WordPress site using the WP-CLI command wp post meta get. If the postmeta value is not "null", then the script prints the post ID to the console. This script allows you to quickly find all posts on your site…

search-post-meta.sh

#!/bin/bash

# Prompt the user to enter a postmeta key to search for
read -p "Enter the postmeta key to search for: " postmeta_key

# Find all posts with the specified postmeta key
post_ids=$(wp post list --format=ids)
for id in $post_ids
do
  meta_value=$(wp post meta get $id $postmeta_key --format=json)
  if [ -n "$meta_value" ]
  then
    echo $id
  fi
done