iOS Shortcuts User Guide on Apple’s Website

Apple has released a great guide for their new Shortcuts app on their website. It’s the best starting point if you want to dive into Shortcuts and work out how it can make your automated life easier. 

There’s also a great resource on macsparky.com for anyone who prefers to learn by watching videos. It’s not free but it’s worth checking out!

Last, but most certainly not least: there’s much more on macstories.net!

Deleting Yoast SEO metadata for a Custom Post Type

I needed to delete 20.000+ rows in the wp_postmeta table which related to a Custom Post Type and Yoast SEO. The SQL I ended up using was this:

DELETE pm 
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.post_type LIKE '%CUSTOMPOSTTYPENAME%'
AND pm.meta_key LIKE '%_yoast_%'

IMPORTANT: Don’t try this at home. And backup your database! I’m not responsible for any case of data loss!