Delete oldest wordpress post (SQL query)

I figured it out! Pretty simple actually.. You can replace post_date_gmt with ID depending on your needs. post_author != 1 will prevent the admin’s post from being deleted, so the menu links and pages will stay intact 🙂

function deleteOldestPost(){
    global $wpdb;
    $prefix = $wpdb->prefix;
    $wpdb->query("DELETE
        FROM ".$prefix."posts where post_author != 1  order by post_date_gmt asc limit 1");
}
add_action('publish_post', 'deleteOldestPost');

There will be some transient data, i.e. wp_term_relationships. Any of the database optimize plugins will get rid of them.

Related Posts:

  1. Function returning queried meta value based on current post ID
  2. Multipart/formatted MySQL query problem
  3. Is it good practice to use wpdb->query() function?
  4. Is there a WP function to get taxonomy name from taxonomy_term_id?
  5. Writing a function for WP Cron to run a SQL command daily
  6. sort title descending with title with number
  7. How do you properly prepare a %LIKE% SQL statement?
  8. What SQL Query to do a simple find and replace
  9. Return only Count from a wp_query request?
  10. Is there a way to list all used/unused WP templates?
  11. Order posts (across the whole site) by metadata date
  12. wpdb get posts by taxonomy SQL
  13. Filter the query ONLY for the search results page
  14. wpdb->prepare function remove single quote for %s in SQL statment
  15. Inserting Post Meta From SQL
  16. How to make an activities stream mixing posts and comments?
  17. mysql custom wp query
  18. SQL query equivalent to WP User Query
  19. Delete post revisions on post publish
  20. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  21. my function doesn’t return my post from today
  22. Query WordPress database by registered date and role
  23. Removing the first image in content
  24. Check if row exists before inserting
  25. wpdb_prepare with multiple or condition
  26. exclude a category from a search on a specific page
  27. How to correctly pass values to wpdb->prepare()?
  28. What’s wrong with my $wpdb prepare?
  29. example of build_query function?
  30. Why is variable not working on custom sql query using wpdb?
  31. Get stock by custom meta field on all Woocommerce variable products
  32. Shortcode pagination not advancing
  33. Display fields as values in array from external SQL DB
  34. WSoD being caused by this piece of code
  35. Advanced SELECT query with condtional statements
  36. How do I see the mysql query generated by get_posts( $args )?
  37. Create table from array with prepare
  38. $wpdb->insert() does not Insert record in a table
  39. wpdb query problem to access previous 3 days posts
  40. WordPress SQL Issue not returning correct reselts
  41. I can’t figure out what’s wrong with this statement. $wpdb->query update
  42. Making a query to the DB using same parameters of loop
  43. Connecting to a 2nd DB gives me no results when querying
  44. Cannot get wpdb data (Error in a simple fuction) [closed]
  45. How to ignore posts in pre_get_posts?
  46. wpdb COALESCE won’t work
  47. Make a SQL query with wpdb in WordPress
  48. Custom Query – Based on user input
  49. Best practice to limit results in get_row()?
  50. Placing a widget with $wpdb query
  51. Use $wpdb or other PHP script method to find/replace in WP database
  52. How can I add a new row in a separate database when someone registers via WordPress?
  53. Get posts from category with custom query
  54. How to use mysql LIKE with wpdb?
  55. PHP -> SQL Query with Summing
  56. Query Column of Specific ID from Database Table
  57. Valid SQL query return empty
  58. mysql query – how to escape apostrophe?
  59. $wpdb->prepare affecting the query?
  60. wp_usermeta – Read from database, but save function broken
  61. Updating with $qpdb->query() always returns 0 rows affected
  62. Why my query does not run with prepare
  63. WordPress Insert not working with ajax
  64. mySQL queries are executed twice on wordpress website
  65. Get the alphabetical sorted data with wpdb
  66. WordPress Mysql query and Duplicate
  67. making php value numeric
  68. How do I query for posts by custom meta and those that have been stickied?
  69. WordPress Categories: Function using custom SQL to return array of specific category IDs
  70. SQL error with custom query
  71. How to avoid saving empty data to sql while using add_meta_box
  72. This code is supposed to only allow user to be authenticated if accountVerified is equal to 1, but it still allows user to be authenticated otherwise
  73. Using One Function To Create Two Different Shortcodes
  74. Database SQL query error
  75. How can I connect to a second database and still be able to use wp functions like get_post_types()?
  76. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  77. Customising the default wordpress search functionality
  78. Any way to use FETCH_KEY_PAIR with $wpdb?
  79. Why isn’t comment validation working?
  80. SQL query to delete users with multiple meta keys and comments
  81. WordPress Database Query works in phpMyAdmin but not in the code
  82. Shortcode with pagination advancing multiple queries
  83. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  84. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  85. Fastest and most efficient SQL query to check if UID exists
  86. What argument does my function need to echo get_results() query results
  87. How can I display a query in a page?
  88. $wpdb query for price in custom field value
  89. Database SQL Error, Should Work
  90. Database Query not working
  91. Run an update query in a function
  92. How to add next height number in Order Attributes inside the Add new page. [duplicate]
  93. Wpdb generates too many queries
  94. Custom WordPress SQL Query 4 posts per custom taxonomy
  95. Mysql query and odd results
  96. Query is not work
  97. Sorting date results from a query
  98. How to Delete Posts by title?
  99. Get all the related data from WordPress DB
  100. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta