WP SQL – Delete specific post meta

If you used to add a specific custom field to your posts but do not need it anymore, you can remove the undesired meta quickly with this query.

DELETE FROM wp_postmeta WHERE meta_key = 'YourMetaKey';

→ Source: http://www.esoftload.info/10-sql-statements-for-wordpress