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. Deleting WordPress posts and media files based on author via MYSQL database
  42. SQL errors when querying for something with apostrophes
  43. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  44. Rename a table in MySQL
  45. How should I tackle –secure-file-priv in MySQL?
  46. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  47. Error Code: 2013. Lost connection to MySQL server during query
  48. 1052: Column ‘id’ in field list is ambiguous
  49. 1052: Column ‘id’ in field list is ambiguous
  50. What SQL Query to do a simple find and replace
  51. Checking if Database Table exists
  52. How to fetch Data in WordPress using MySQLi or $wpdb
  53. Connect to database using wordpress wp-config file
  54. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  55. How to define composite keys with dbDelta()
  56. Is it possible to define two databases for one installation?
  57. “MySQL server has gone away” since update to 3.8
  58. Scheduling posts in database
  59. Emojis getting converted to “?”
  60. Query from a different database than the default
  61. Replace/Mute/Stop Search Query
  62. Migrating to WordPress Recipe Plugin and Some SQL Issues
  63. How to prevent/delay MySQL connections when an object cache is used?
  64. Migrating from PDO using SQLite to clean new install using MySQL
  65. $wpdb->insert Giving duplicates
  66. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  67. Duplicated site isn’t recognized as a site
  68. Changing root password in PHPMyAdmin for WordPress Database when going live
  69. How to properly check if a table exists in WordPress Database using Show Tables Query
  70. How and where is wordpress adding mySQL content to database?
  71. Using AND and bracket grouping in SQL not working
  72. Is my way to change WordPress server is correct?
  73. How to delete a particular row in a database table
  74. Files on Localhost, Database on Server
  75. mySQL queries are executed twice on wordpress website
  76. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  77. custom tables in wordpress Database? (can i just create them with sql?)
  78. Accidently changed the GUID
  79. Replacing javascript link in WordPress database without getting mysql syntax errors
  80. how to access 2nd Mysqli Database from different server for wordpress
  81. Error establishing a database connection – WordPress setup, everything else is working
  82. Help posting values to DB on submit using $wpdb->query
  83. How to map data on CSV to web pages?
  84. Search and Replace in Windows XAMPP site
  85. The function is deprecated; use mysql_real_escape_string() instead
  86. How can i syn wordpress user table with a stand-alone php script?
  87. insert data from a form:: Warning Empty query mysqli::query()
  88. How to get specific table by current user login
  89. How can we speed up wp_get_nav_menu_items()?
  90. $wpdb not working
  91. WordPress Database Posts Table query
  92. Extracted CSV as Array for Custom Query Loop
  93. Hang Up Followed By Can’t select database
  94. Generating an HTML table from an array based on dynamic key values
  95. Mysql Queries per Visit – Crazy High
  96. How to make MySQL search queries with quotes
  97. WP_Query always returning the last custom post
  98. using same mysql user with many databases
  99. Why are my WordPress post queries so slow?
  100. Custom wordpress SQL statement for a website