Using python to delete specified text from thousands of old blog posts

No need to over complicate things by developing a script to do what you want and to end your misery. You can do this using SQL, presuming you have access to the database.

If you are using MySQL 8+, you can use PREG_REPLACE in a query, as suggested in this SO article: How to remove all tag from column using a SQL query

UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '<img.*?/>', '')
WHERE post_content LIKE '%<img%';

Note – it is strongly recommended to make a back up of your website or, at least, the database before doing any SQL operations.

Related Posts:

  1. How can I login to a website with Python?
  2. Upload file to SFTP using PowerShell
  3. Best way to automate the page/post publication process?
  4. Automating Page Creation
  5. Is there any free (or cheap) software that can be used for testing WordPress functionality?
  6. Is it possible to populate my wordpress site with many random posts for testing purposes?
  7. Automating Excerpt
  8. Are plugins like WP Robot considered as spammy by the community?
  9. Automatic publishing after some fixed intervals?
  10. WordPress Body Content How to add current page title automatically in different places?
  11. numpy array: IndexError: too many indices for array
  12. How do I specify new lines on Python, when writing on files?
  13. How to iterate over rows in a DataFrame in Pandas
  14. bash: pip: command not found
  15. TypeError: ‘NoneType’ object is not iterable in Python
  16. How do I check what version of Python is running my script?
  17. How to convert list to string [duplicate]
  18. How to uninstall a package installed with pip install –user
  19. Converting integer to string in Python
  20. Python for-in loop preceded by a variable
  21. What does if __name__ == “__main__”: do?
  22. How to measure elapsed time in Python?
  23. not all arguments converted during string formatting.. NO % variables
  24. TypeError: ‘builtin_function_or_method’ object is not subscriptable
  25. numpy max vs amax vs maximum
  26. What does “while True” mean in Python?
  27. TypeError: ‘str’ object is not callable (Python)
  28. ModuleNotFoundError: No module named ‘sklearn’
  29. Does Python have an ordered set?
  30. python re.split() to split by spaces, commas, and periods, but not in cases like 1,000 or 1.50
  31. Asking the user for input until they give a valid response
  32. Print a list in reverse order with range()?
  33. Configuring so that pip install can work from github
  34. Proper way to declare custom exceptions in modern Python?
  35. TypeError: ‘float’ object not iterable
  36. write() versus writelines() and concatenated strings
  37. Why is it string.join(list) instead of list.join(string)?
  38. How to read a .xlsx file using the pandas Library in iPython?
  39. What is a Python egg?
  40. Numpy/Python Array Value error
  41. Changing the “tick frequency” on x or y axis in matplotlib?
  42. TypeError: unsupported operand type(s) for -: ‘str’ and ‘str’
  43. Remove all special characters, punctuation and spaces from string
  44. AttributeError: ” object has no attribute ”
  45. Plot pie chart and table of pandas dataframe
  46. ModuleNotFoundError: No module named ‘matplotlib’
  47. Install mysql-python (Windows)
  48. “inconsistent use of tabs and spaces in indentation”
  49. Grep and Python
  50. What does the percentage sign mean in Python
  51. Pandas ‘count(distinct)’ equivalent
  52. How can I flush the output of the print function?
  53. Python calling method in class
  54. No module named pkg_resources
  55. TypeError: list indices must be integers or slices, not str
  56. python object() takes no parameters error
  57. Inorder Binary Tree Traversal (using Python)
  58. How do I find the distance between two points?
  59. How do I calculate percentiles with python/numpy?
  60. Why is IoC / DI not common in Python?
  61. How do I remove a substring from the end of a string?
  62. Selecting with complex criteria from pandas.DataFrame
  63. Is ‘# -*- coding: utf-8 -*-‘ also a comment in Python?
  64. How can I download Anaconda for python 3.6
  65. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  66. Replace and overwrite instead of appending
  67. How to make a histogram from a list of data
  68. Using __add__ operator with multiple arguments in Python
  69. How to constantly run Python script in the background on Windows?
  70. Django – “no module named django.core.management”
  71. Type error Unhashable type:set
  72. How can you print a variable name in python? [duplicate]
  73. Windows path in Python
  74. Python: ValueError: Mixing iteration and read methods would lose data
  75. python: restarting a loop
  76. “for loop” with two variables?
  77. Display number with leading zeros
  78. Running Python in PowerShell?
  79. Why do many examples use `fig, ax = plt.subplots()` in Matplotlib/pyplot/python
  80. ImportError: No module named model_selection
  81. Numpy – add row to array
  82. How to change pip installation path
  83. What is the difference between a string and a byte string?
  84. Rolling or sliding window iterator?
  85. What is a namespace object?
  86. How to serve static files in Flask
  87. How to create Gephi network graphs from Python?
  88. strncmp in python
  89. How can I count time in Python 3?
  90. Is it possible to forward-declare a function in Python?
  91. Python OpenCV2 (cv2) wrapper to get image size?
  92. Modular multiplicative inverse function in Python
  93. KeyError: ‘plotly_domain’
  94. The value of _stdout is incorrect
  95. Can I do in-page changes binding events/triggers to actions in WordPress?
  96. How to auto-generate names for guest users who leave comments?
  97. Assignt automatically two categories by author
  98. WordPress NOT notifying of new update in dashboard
  99. Importing large number of RSS feeds
  100. Automate the installation of postfix on Ubuntu