Ideas how to search & replace post_content when string contains a newline?

that was easy to do directly in sql:

UPDATE wp_posts 
SET post_content = replace(post_content,'</div>\r\n\r\n<div id="postbottom">','</div><div id="postbottom">');

Related Posts:

  1. Searching With Apostrophe
  2. How to make MySQL search queries with quotes
  3. what are the numbers between curly brackets in search query
  4. simple sql query on wp_postmeta very slow
  5. How many WordPress SQL Queries per page?
  6. Search custom post type by meta data
  7. Multipart/formatted MySQL query problem
  8. Search and replace text across all posts
  9. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  10. Fulltext search in posts sorted by relevancy
  11. Custom Query to search through categories
  12. search through post-type attachments titles
  13. Are database queries created using WordPress filters protected from SQL injection?
  14. Grouping related postmeta data via SQL query
  15. Mysql / WordPress killing my server with 80k users [closed]
  16. Slow meta_query with about 4 milion record on wp_postmeta
  17. Select User by Joining Multiple Meta Value Results
  18. mySQL query. ORDER BY meta_key
  19. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  20. Change searched term
  21. Update slug (URL) of pending posts via phpMyAdmin
  22. My SQL function to change user_name
  23. You have an error in your SQL syntax – Help with query
  24. MySQL variable in query
  25. Search query -> Show all pages except certain template
  26. Temporarily storing main search result
  27. how would I create a custom query to get all users, and a related post based on a postmeta field?
  28. Help with MySQL to $WPDB query
  29. SQL query to select posts from multiple categories
  30. How do I see the mysql query generated by get_posts( $args )?
  31. Alter query with posts_clauses to retrieve NULL values last
  32. Query based on title, with ‘compare’ => ‘IN’
  33. is_search called incorreclty
  34. MySql Query very slow
  35. Attempt to improve WP search, can someone check my SQL query?
  36. WordPress Query wp-terms SLOW
  37. wpdb COALESCE won’t work
  38. How to reset usual $query on search page to push custom $wpdb query there?
  39. Get posts from category with custom query
  40. how to insert missing tags into the posts through mySQL?
  41. How to insert Collate into WordPress search query?
  42. Valid SQL query return empty
  43. mysql query – how to escape apostrophe?
  44. Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
  45. Query the WordPress database to get data together with replaced information
  46. How to interfere to default search to make it search in custom fields?
  47. Optimize slow SQL query for multiple meta values
  48. Updating with $qpdb->query() always returns 0 rows affected
  49. How to manage a particular “order by” for get_search_query()?
  50. How to return count of custom post type posts with a specific custom field value via $wpdb?
  51. WordPress Mysql query and Duplicate
  52. Help with Related Posts Function
  53. How to delete all images from code in all post_content
  54. WordPress search in modified post title
  55. Filter orders by modify date
  56. How to add url parameter to every search query in SearchWp?
  57. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  58. Add rewrite rule for archive search
  59. Displaying data from custom table
  60. SEO friendly query vars
  61. Get 2 meta values from meta key column
  62. Restrict WordPress search to a single ACF field
  63. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  64. SQL query to delete users with multiple meta keys and comments
  65. Modify behaviour of “s” parameter in wp_query
  66. Sort by postmeta on when searching
  67. OR condition not working
  68. Trouble migrating custom post types from non-wordpress cms
  69. Pagination adds search query (again)
  70. Speed up search query that searches in post meta?
  71. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  72. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  73. $query->set( ‘post_type’, ‘post’ ); not working
  74. Custom MySQL Query for Post and Post Meta
  75. search.php is not generating the right results
  76. Run search query again without pagination gives no results?
  77. Mysql query and odd results
  78. sql for querying post and their category
  79. Access Tables with number prefix
  80. Is there a way of increasing the speed of this query?
  81. When/why does ‘$query->get( ‘tax_query’ );’ return empty?
  82. How to get link and title of next and previous post on single page
  83. query multiple taxonomy and show post count
  84. How can I get all posts data from within a paginated search result?
  85. Query Posts By Post Publish Date, but sort by Custom Meta Key
  86. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  87. Editing the default wordpress search
  88. wpdb query problem to access previous 3 days posts
  89. Related post based on content
  90. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  91. Declaring a var, placing it in a query and using the output of the query?
  92. How to create a filter and add query params to all links
  93. My custom pagination not displaying
  94. SQL query to bulk change short code in all posts
  95. Wpdb->last_query returns bad query
  96. WP search exclude last letter from string
  97. Wpdb empty result only if language is Russian
  98. Query unique author ids with published post of type job
  99. Conditional Tag Custom Querys?
  100. Query filter on custom post by current author in post widget for elementor query id