flush-corrupted-oembeds.sh

cd /path/to/root
for id in $(wp site list --field=blog_id)
do
    echo ${id}
    mysql -h##HOST## -u##USER## -p##PASSWORD## -e "DELETE FROM wp_${id}_postmeta WHERE meta_key LIKE '_oembed_%' and meta_key NOT LIKE '_oembed_time_%' and meta_value NOT LIKE '%>' AND meta_value != '{{unknown}}';" ##DB_NAME##
    echo Flushed dodgy OEmbeds from site ${id}
done

Hey Daniel,

Do you know how I could convert this into a PHP script that I could create a daily cron job for so that my site could daily check for corrupt oembed caches?