Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin

if you want to keep the row with the lowest id value:

DELETE n1 FROM table n1, table n2 WHERE n1.id > n2.id AND n1.meta_key = n2.meta_key

OR if you want to keep the row with the highest id value:

DELETE n1 FROM table n1, table n2 WHERE n1.id < n2.id AND n1.meta_key= n2.meta_key

Related Posts:

  1. Query WordPress database by registered date and role
  2. SQL query to set posts in bulk based on the post content
  3. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  4. Inserting Post Meta From SQL
  5. Change SQL get_results to search for posts with custom term in custom taxonomy
  6. Change all http to https in mysql databse?
  7. WooCommerce – Query for ordered products
  8. How to execute mulitple statement SQL queries using $wpdb->query?
  9. Size article thumbnails and retrieve them directly from database
  10. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  11. Select Multiple meta_value from WP DB; Single Query
  12. wpdb_prepare with multiple or condition
  13. SQL Error wp_commentmeta – incorrect table definition
  14. CRUD operations using WordPress database API
  15. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  16. How do I get the posts within a certain year/date(with sql query)?
  17. Advanced SELECT query with condtional statements
  18. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  19. Create table from array with prepare
  20. How to fix database error duplicate entry
  21. Query multiple tables at once?
  22. Custom WordPress Table wpdb
  23. Why this query is not showing any result on wordpresss home page?
  24. Best practice to limit results in get_row()?
  25. Why does changing Database Table Prefixes result in loss of content?
  26. Query Column of Specific ID from Database Table
  27. $wpdb->get_var – What value is returned when zero records are found?
  28. How to display data from db in select list [closed]
  29. DB prefix not updating
  30. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  31. Job and Employee Performance Tracking with Product Safety
  32. WordPress Database Query works in phpMyAdmin but not in the code
  33. How to create index (sql) to a meta_key?
  34. Delete all users meta that named: user_avatar
  35. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  36. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  37. export individual posts to text files or a single csv file
  38. SQL query : Select a thumbnail for a media
  39. why you don’t Implement PDO for access every thing to database
  40. SQL query to rewrite all media URLs to end with .webp
  41. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  42. Rename a table in MySQL
  43. How should I tackle –secure-file-priv in MySQL?
  44. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  45. Error Code: 2013. Lost connection to MySQL server during query
  46. 1052: Column ‘id’ in field list is ambiguous
  47. 1052: Column ‘id’ in field list is ambiguous
  48. How to do a batch insert in MySQL
  49. What SQL Query to do a simple find and replace
  50. Checking if Database Table exists
  51. How to fetch Data in WordPress using MySQLi or $wpdb
  52. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  53. How to define composite keys with dbDelta()
  54. Is it possible to define two databases for one installation?
  55. Display data from a non wordpress database on a page template
  56. Bulk Update of Custom Post Type Post Status through SQL
  57. How do I add indexes to WordPress Database?
  58. Huge wp_options table
  59. “MySQL server has gone away” since update to 3.8
  60. WordPress and automated MySQL backups to a different host
  61. Scheduling posts in database
  62. Emojis getting converted to “?”
  63. Query from a different database than the default
  64. Bulk-create posts from SQL database
  65. Replace/Mute/Stop Search Query
  66. How to prevent/delay MySQL connections when an object cache is used?
  67. How to paginate information obtained from a query to a custom table?
  68. Error establishing a database connection,
  69. Is it possible to query from external database? [duplicate]
  70. Can’t update WordFence Options, clear data manually
  71. Changing between Local Host DB to Production DB and in reverse
  72. Is it possible to have more than 1 MySQL database in my WordPress blog?
  73. How and where is wordpress adding mySQL content to database?
  74. Using AND and bracket grouping in SQL not working
  75. Connecting to a different database
  76. Delete/Replace words from X to Y in post content
  77. How to delete a particular row in a database table
  78. How to create more than one new wpdb object?
  79. Remote database -> massive response time increase?
  80. Getting value from database table depending on field value
  81. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  82. Cloning blog to localhost via WAMP
  83. SQL error with custom query
  84. custom tables in wordpress Database? (can i just create them with sql?)
  85. Accidently changed the GUID
  86. How to edit custom table data in frontend
  87. local wordpress broke after changing URL
  88. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  89. Help posting values to DB on submit using $wpdb->query
  90. wpdb query to insert images in to post/page gallery
  91. How to set posts to draft in bulk based on the content of the post
  92. WPCLI search and replace in a particlar site dir effect another site-dir
  93. Performance bug – slow DB query
  94. $wpdb not working
  95. Extracted CSV as Array for Custom Query Loop
  96. Hang Up Followed By Can’t select database
  97. Why is converting my database to UTF-8 truncating entries?
  98. Pulling values from a sepcific row in table
  99. Using class id from array for query
  100. WordPress database connection failed, while mysql client is working [closed]