I found this from just a Google search (Source)
You have to change met value keys as you want. However, it is highly recommend to take a DB backup before running this code.
<?php
function delete_useless_post_meta() {
global $wpdb;
$table = $wpdb->prefix.'postmeta';
$wpdb->delete ($table, array('meta_key' => '_edit_last'));
$wpdb->delete ($table, array('meta_key' => '_edit_lock'));
$wpdb->delete ($table, array('meta_key' => '_wp_old_slug')); }
add_action('wp_logout','delete_useless_post_meta');
?>
Related Posts:
- Get posts by meta value
- Execute action after post is saved with all related post_meta records (data)
- advanced custom fields update_field for field type: Taxonomy
- update_post_meta not saving when value is zero
- Restrict post edit/delete based on user ID and custom field
- get_post_meta returning empty string when data shows in the database
- publish_post action hook doesn’t give post_meta_data
- How to access the post meta of a post that has just been published?
- How to get all term meta for a taxonomy – getting term_meta for taxonomy
- Should I sanitize custom post meta if it is going to be escaped later?
- Front-end update_post_meta snippet displays white screen?
- Query between two meta values?
- How to get meta value in wp_attachment_metadata
- List posts under meta_value heading
- loop through all meta keys with get_post_meta
- Get post from meta_key and meta_value
- get_post_meta returns bool(false)
- How to get custom post type to display post meta on archive pages?
- How to use post_id with a Class?
- Saving html into postmeta without stripping tags – safe?
- How to show Published date and/or Modified date
- Set default Custom Post Meta Value
- wp_update_user isn’t instantly?
- INSERT ON DUPLICATE KEY UPDATE failes in postmeta table
- Set Checkbox as checked by default
- How to use update_post_meta inside wp_trash_post
- “update_post_meta” not working in “wp_insert_post_data” hook
- replacing the_autor or make callback
- Display All Custom Post Fields and Values, Unless Empty
- How to create a meta_query to get all posts with a specific meta data?
- Save an array of values in the post meta box
- hide posts with specific meta data from admin page
- Post MetaTable Overload
- get_post_meta() empty in preview WHEN custom post is published [closed]
- Custom RSS Feeds & Post Meta Data
- $wpdb class updating meta_value using Ajax [closed]
- get_post_meta not extracting title,permalink and posttype
- How to selected which tags to print, instead of printing the whole tag list?
- Display get_post_meta if contains value
- Save post meta foreach loop
- Should I save this mulit dementional arary as one post meta?
- Sort Posts By Custom Field Date?
- Difficultly changing date format in post meta value
- Remove last character in get_post_meta
- mass delete posts based on metadata
- How to obtain a group of post meta and assign each meta to other variables?
- “Cannot use import statement outside a module” JS error while adding a custom meta block?
- Duplicate rows in meta table, any known relations in WC?
- Adding Custom MetaData
- Suggestion to make posts have multiple associated items
- How to properly use oneOf and anyOf in Rest Schema?
- update_post_meta in loop changing ALL values
- Get the author meta adds now
- Why is my get_post_meta not properly calling the custom field when attempting to embed a YouTube video?
- show ad after # paragraphs
- If ACF meta_key has meta_value
- How to echo value of a meta select box to the browser
- How can I use ‘orderby’ => ‘meta_value_num’ to order by the numerical value even if the value starts with a word?
- New Table vs Post / Comment Meta
- Repeated nav bar queries failing to be cached
- Randomizing Post Links Outside of Loop – No Author or Date
- How do I add a fixed value to get_post_meta();?
- Add post’s category as a meta tag to the post
- Insert Custom Field Value
- How can I query for posts using a date stored in post-meta?
- SQL query – get a featured image’s alt / alternative text
- get specific values from WordPress meta_value
- Is duplicate `_wp_attachment_image_alt` meta key allowed?
- How do I list taxonomies that have upcoming events in WP? Is there a way to do this without having to query posts first?
- How can i set media attachments to the author of the post or page for already existed posts with attachments
- Strict comparisons problem when using boolean post meta
- Why is the actual number of thumbnail images not matching what is store in an attachments metadata?
- How to get posts by meta value as multi-dimensional array?
- Add post meta data date to event
- How to modify default meta link format
- Something adding an excessive meta description
- Get table parameter and save in meta value
- How can i show post views using specified post ID?
- How to add/update post meta to use in query?
- gettext localization is not working
- how to query posts using value in meta post array
- Why doesn’t wp_oembed_get() for the video post format not work?
- Custom Meta Fields that are Echo’d are removed on post update?
- How to add dynamic content in title and meta description in wordpress theme for homepage, post page, category, tag and pages
- How to call get_post()?
- Exclude category from DB query
- add_post_meta only adding 1 character
- How to sort by meta value num, but ignore zero value?
- Posts with no meta field do not appear when sorting by meta field
- How do I delete element from a serialized array upon deletion of a post?
- Fetch post meta data on POST request
- Which query method to use? (edit- wpdb syntax problems)
- Get meta information from post parent
- How to update post meta with xml data
- Counting number of identical meta keys
- How we insert values into database using metabox WordPress?
- query with custom field
- Using Form to alter PHP variable [closed]
- Chance post id into post name
- Save frontend submission form field as custom field