How to delete duplicate records in wp_postmeta database table?

You don’t need a select statement to do this, a DELETE statement can handle finding the records. Make sure to backup your database first, then try the following SQL query.

DELETE FROM wp_postmeta
WHERE meta_key = 'cb_full_width_post'
AND meta_value != 'nosidebar-narrow'

Related Posts:

  1. Lack of composite indexes for meta tables
  2. Safe to delete blank postmeta?
  3. delete unused postmeta
  4. Save both current and new version of post meta
  5. Triple meta_key on custom SELECT query
  6. How to get the total number of meta_values based on a custom post type?
  7. MySQL Query To Select Post By Postmeta
  8. delete duplicates wp_postmeta
  9. why is my postmeta table is so heavy
  10. Display multiple meta_key/meta_values by single SQL query
  11. Using mysql queries to delete custom post types based on meta_value
  12. Export posts with postmeta without ID?
  13. Remove duplicate rows in MySQL
  14. How do I retrieve the slug of the current page?
  15. Most efficient way to get posts with postmeta
  16. Get posts by meta value
  17. Explanation of update_post_(meta/term)_cache
  18. How to extract data from a post meta serialized array?
  19. How to save an array with one metakey in postmeta?
  20. WordPress is stripping escape backslashes from JSON strings in post_meta
  21. How can I get the post ID from a WP_Query loop?
  22. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  23. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  24. Use REGEXP in WP_Query meta_query key
  25. How to update_post_meta value as array
  26. Adding meta tag without plugin
  27. What’s the point of get_post_meta’s $single param?
  28. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  29. How to edit a post meta data in a Gutenberg Block?
  30. Sanitizing integer input for update_post_meta
  31. post formats – how to switch meta boxes when changing format?
  32. Execute action after post is saved with all related post_meta records (data)
  33. Get a single post by a unique meta value
  34. if get_post_meta is empty do something
  35. How we get_post_meta without post id
  36. How get post id from meta value
  37. What is the code to get the download link for a product in WooCommerce?
  38. advanced custom fields update_field for field type: Taxonomy
  39. update_post_meta not saving when value is zero
  40. Content hooks vs User hooks
  41. Meta compare with date (stored as string) not working
  42. Trying to get custom post meta through Jetpack JSON API [closed]
  43. How to update/insert custom field(post meta) data with wordpress REST API?
  44. Restrict post edit/delete based on user ID and custom field
  45. get_post_meta returning empty string when data shows in the database
  46. publish_post action hook doesn’t give post_meta_data
  47. Remove WordPress.org Meta link
  48. Remove post meta keys
  49. How to access the post meta of a post that has just been published?
  50. Why time functions show invalid time zone when using ‘c’ time format?
  51. Why is get_post_meta returning an array when I specify it as single?
  52. How to update/delete array in post meta value?
  53. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  54. Adding an assisting editor box to Post page
  55. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  56. importing data from non-wordpress mysql db
  57. Should I sanitize custom post meta if it is going to be escaped later?
  58. Add post meta based on another post meta value before publish post
  59. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  60. Front-end update_post_meta snippet displays white screen?
  61. Query between two meta values?
  62. Get Advanced Custom Fields values before saving [closed]
  63. Give extra post-meta to RSS feeds
  64. How to get meta value in wp_attachment_metadata
  65. How to count post meta key values for all posts in database
  66. WP REST API “rest_no_route” when trying to update meta
  67. Clean up output added via wp_head()
  68. List posts under meta_value heading
  69. Why am I getting an infinite loop with have_posts?
  70. get_post_meta – get a single value
  71. Group posts by meta_key
  72. delete value 0 in post meta [closed]
  73. How to solve slow WordPress site caused by attachment_metadata
  74. Can I safely delete a record, manually, in the wp postmeta table?
  75. How to store post meta in an array?
  76. What action hook updates post meta?
  77. Can’t translate the post meta data (Date) in another language
  78. get_post_meta / update_post_meta array
  79. adding a URL to a post meta
  80. Would this post meta be better added to the post table rather than post_meta table
  81. Exclude a category from the filed under list
  82. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  83. How do I access post meta data when publishing a new post in Gutenberg?
  84. update_post_meta() not working when used with WordPress action
  85. Delete all post meta except featured image
  86. Using Advanced Custom Field (ACF) to insert meta description on each page
  87. get_post_custom()
  88. Adding meta data to an attachment post
  89. update_post_meta not adding anything.(Nor add_post_meta)
  90. loop through all meta keys with get_post_meta
  91. Get posts by meta value with date
  92. How to add meta tag to wordpress posts filter?
  93. Move value of one custom field to another
  94. How can I free up the memory used by update_post_meta?
  95. Are multiple values from get_post_meta guaranteed to be ordered?
  96. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  97. Identifying Importer Posts
  98. Get updated post meta on save_post action?
  99. Get post from meta_key and meta_value
  100. Add a post metadata if only the key and value does not exist