Support » Fixing WordPress » SQL query to delete postmeta
5 years, 6 months ago
i used this SQL command to select at the unused postmeta
but i want to delete them, and could’nt figure out how
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL LIMIT 30;
I think this is right.
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;
This code comes with no warranty or promise of fitness for any purpose whatsoever. Test it on a development server with dummy data or may god have mercy on your soul.