SQL query to delete postmeta

  • Resolved magicpadx

    (@magicpadx)


    13 years, 7 months ago

    hi,

    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;

Viewing 2 replies - 1 through 2 (of 2 total)

  • I think this is right.

    DELETE pm
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.

    Thread Starter magicpadx

    (@magicpadx)

    perfect,

    thx man

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL query to delete postmeta’ is closed to new replies.

Tags