Removal of all posts content in bulk, keeping the posts itself

Do not run this on a live site until you’re tested it on a backup or local installation and confirmed valid results, i won’t take any resposibility for lost data, should that occur.

SQL Query

To run from PhpMyAdmin

UPDATE wp_posts SET post_content="your_content" WHERE post_type="post"

Inside WordPress

To use inside a plugin or your functions file (run once)

global $wpdb;
$my_update_query = $wpdb->get_result( "UPDATE $wpdb->posts SET post_content="your_content" WHERE post_type="post"" );

Related Posts:

  1. Undefined function mysql_connect()
  2. MySQL column count doesn’t match value count at row 1 [closed]
  3. Fatal error: Call to undefined function mysql_connect()
  4. the_date() not working
  5. How to return number of found rows from SELECT query
  6. dbDelta support for FOREIGN KEY
  7. Check if post of title already exists
  8. $wpdb->delete column values IN ARRAY()?
  9. How to make WordPress plugin check for database changes and then do something?
  10. Custom SQL query to get List of posts with featured image url
  11. Does WordPress cache get_user_meta() results?
  12. Delete post revisions on post publish
  13. Problems migrating WordPress to localhost
  14. error importing localhost export file to server
  15. How to sort results from a custom database table
  16. Update some database fields when post is saved
  17. Successful or Error Message after running mysql code in functions.php
  18. sql query to put quotes around numbers in img tag
  19. PHP/MySQL issues when running WP on EC2 cloud [closed]
  20. WordPress get pagination on wpdb get_results
  21. How to create another version of my site based on the same database
  22. What SQL / WordPress queries would need a nonce?
  23. Different database query in function.php using mysqli
  24. Strange wordpress slowness
  25. Looking for most performant way to execute several similar WP queries within shortcodes
  26. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  27. Stumped on migration
  28. PHP code inside shortcodes
  29. Show MySQL errors that occur when I excute $wpdb->insert()
  30. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  31. WordPress Site Running Extremely Slow on Dedicated Server
  32. Get updated query results on page after insert in database
  33. WordPress not reflecting changed of the database
  34. How can I fix WordPress installation errors?
  35. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  36. Hacked WordPress website /Homepage redirect [closed]
  37. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  38. Refresh table data with Ajax
  39. Database query works fine outside WordPress
  40. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  41. Help with a $wpdb MySQL Query
  42. How i can obtain all the post meta for a specific post as an array?
  43. multiple where condition in result query
  44. Can’t Query Custom Table Using $wpdb Method
  45. $wpdb returns duplicate posts
  46. Update postmeta after theme switch
  47. Should I use WordPress to skin a database website?
  48. Creating Database Table vs. Adding MetaData to Post & User
  49. WordPress Custom SQL Table with UserID Filter for results
  50. How can I add a new row in a separate database when someone registers via WordPress?
  51. How to use mysql LIKE with wpdb?
  52. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  53. WordPress WP_Query without query GET parameters
  54. How to use AJAX in WordPress in MYSQL query?
  55. Use variable in SQL statement
  56. Processing ajax call to php to insert into mysql database
  57. WPDB secure custom form
  58. Query the links Database
  59. WordPress Custom Query: Combining Two Functions
  60. MySQL Query Returns Array () In Shortcode
  61. How to WP_Query posts order by parent title?
  62. Passing in MySQL prepare statement parameter separately throwing error
  63. Convert a column of a table containing an Array as response in HTML
  64. Database SQL query error
  65. Please help! I have a problem with getting wordpress databas
  66. How to run complex query using PHP
  67. Error establishing a database connection (Set-up locally)
  68. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  69. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  70. how to get data from two different table from wordpress database
  71. Passing Current User ID into SQL statement
  72. How to optimize and reduce excessive database queries
  73. How to insert multiple rows and columns in database using array
  74. Store GA Client ID in User DB
  75. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  76. Windows Setup: Error establishing a database connection
  77. Need help with format of nested array in MySQL
  78. The plugin generated 225 characters of unexpected output during activation
  79. WAMP SERVER Command Prompt SET PATH=%PATH%
  80. Inserting other fields to existing registration form in a WordPress theme
  81. Advanced WordPress SQL Query
  82. Splitting table data to pages with numbers
  83. How can get all users by current user meta (array)?
  84. Site doesnt work once PHP changed to 7.1
  85. How to detect if a revision was made by woocommerce or wordpress?
  86. WordPress WPDB::insert 13th param is always blank (only if format)
  87. Ajax not updating to database
  88. can’t delete a row from post_meta table
  89. Send data from plugin to external database
  90. MySQL query in WordPress with AJAX
  91. Processing forms with php to wordpress database
  92. How to connect database table to each registered wordpress user.
  93. retrieve wordpress post-meta using php not wordpress functions
  94. Splash pages on a high traffic site
  95. Using the same shortcode to show any table from the database
  96. I am unable to fetch json data from wp_db
  97. Submit cf7 form to cfdb as pdf/BLOB [closed]
  98. How to send push notification in android using php? [closed]
  99. Putting form result in my database
  100. running an existing WordPress site from Visual Studio Code?