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. How do I retrieve the slug of the current page?
  14. Most efficient way to get posts with postmeta
  15. How to extract data from a post meta serialized array?
  16. How to save an array with one metakey in postmeta?
  17. WordPress is stripping escape backslashes from JSON strings in post_meta
  18. How to update_post_meta value as array
  19. What’s the point of get_post_meta’s $single param?
  20. Get a single post by a unique meta value
  21. Content hooks vs User hooks
  22. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  23. get_post_meta – get a single value
  24. How to solve slow WordPress site caused by attachment_metadata
  25. Can I safely delete a record, manually, in the wp postmeta table?
  26. get_post_meta / update_post_meta array
  27. Delete all post meta except featured image
  28. update_post_meta not adding anything.(Nor add_post_meta)
  29. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  30. Identifying Importer Posts
  31. Add a post metadata if only the key and value does not exist
  32. How metadata API works?
  33. Use ajax to update_post_meta
  34. How to sanitize post meta field value?
  35. Post IDs missing on delete_postmeta action hook
  36. How trigger to save post when updating post meta
  37. Create a Metabox that behaves Like a Taxonomy Box
  38. Views count with time limit per IP
  39. order by multiple meta_keys?
  40. conditional function to change post-meta background image
  41. echo image caption
  42. get_*_meta doesn’t always return an array
  43. Generate multiple goo.gl shortlinks for qtranslate bilingual blog
  44. Using hook to use DISTINCT in a wp_query
  45. How can I convert postmeta from unserialized to serialized?
  46. add_post_meta adds meta to one more different post
  47. Custom query, multiple custom keys
  48. Trying to get property of non-object error using get_post_meta()
  49. How can I change the tag contents of individual WordPress posts?
  50. get_post_meta producing white screen of death
  51. update_post_meta not working in plugin
  52. Look up all posts by status or meta value – performance difference
  53. String taken from database table post_meta is showing HTML tags on Frontend
  54. Can A Post Meta Field Store multiple values that are not in an array?
  55. esc_attr on get_post_meta [closed]
  56. Sort custom posts in archive by multiple values: date AND meta key
  57. Delete posts based on post meta data
  58. How is the author’s name given a different color?
  59. How does WordPress treats attachments metadata in post content?
  60. URL to Post Meta [closed]
  61. update_post_meta() adding bits in database [closed]
  62. Get posts ordered by meta data
  63. Displaying values from related field – if empty shows current post type’s link and title
  64. get_post_meta inside echo [closed]
  65. WordPress postmeta: Store data as an array or single item?
  66. Display Post Meta in Header
  67. Array of user ids to list of user names
  68. Conditional For get_the_author_meta
  69. Custom fields or something else
  70. Is there a way combine posts meta_name?
  71. How to avoid saving empty data to sql while using add_meta_box
  72. I want to Add Feedburner Right After Meta Details
  73. if get_post_meta function returns empty – Do Not Display HTML
  74. Custom column on CPT not showing correct value when meta data not set
  75. How to access post meta on the first time a post is published
  76. Removing Malware
  77. I Can’t get the post_tag name from term_id using wp_set_object_terms
  78. After updating the custom post type, metafields disappear from the post.php edit menu, how do I fix it?
  79. How to update/add child posts meta whenever the parent post meta is updated?
  80. How to query post with meta?
  81. update_post_meta() throws Uncaught error: Cannot create duplicate attribute
  82. Using a comma instead of a pipe to separate metadata
  83. show user based on user_meta
  84. Meta keys won’t add using wp_insert_post
  85. How Can I extract Image urls from post meta
  86. Assign postmeta in bulk
  87. How do i get value from wp_postmeta?
  88. Twenty Twelve entry meta data – change and move
  89. Re-order posts inside tax query
  90. How can I prevent the post_modified column in wp_posts from being updated?
  91. Sorting meta box values by start- and enddate and all dates in between
  92. Use an id on a button to update_post_meta in post
  93. get_post_meta image width for lazy load
  94. Custom Fields help
  95. WP-API : post_meta not updated… but have another entry
  96. Parse error thrown by get_post_meta [closed]
  97. How to get all the related ids without array?
  98. Remove action of an external plugin after checking if custom post meta is set
  99. I am stuck between post meta function to call unique id
  100. get_post_meta() returns nothing in save_post, publish_post, wp_after_insert_post
techhipbettruvabetnorabahisbahis forumuedusedueduedueduseduseduseduseduedu