Search and replace in post content

Okay, this always seems to happen to me. I spend ages looking for an answer and finally decide to give up and post here and then one more search finds enough to solve it.

Anyway, this is what worked for me:

update wp_posts set post_content = replace(post_content, '[/tab] 
[tab title="1024x576"]
<table class="screenshot-table">', '[tabby title="1024 x 576"]
<table class="screenshot-table onetwentyfour">');

Simply by putting the multi-line text ON multi-lines worked.

You learn something everyday!

Related Posts:

  1. What SQL Query to do a simple find and replace
  2. What specific database privileges does WordPress need?
  3. Some Post Content Does Not Show Up In DB Search
  4. Global MySQL replacing of text patterns/matches
  5. Cannot add or update a child row: a foreign key constraint fails
  6. How to make MySQL table primary key auto increment with some prefix
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  9. Rename a column in MySQL
  10. Syntax error due to using a reserved word as a table or column name in MySQL
  11. MySQL root password change
  12. Installation of MySQL for Visual Studio 1.2.8 failed
  13. Not unique table/alias
  14. How do I import an SQL file using the command line in MySQL?
  15. Install mysql-python (Windows)
  16. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  17. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  18. Disable ONLY_FULL_GROUP_BY
  19. MySQL WHERE IN ()
  20. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  21. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  22. difference between primary key and unique key
  23. Mysql command not found in OS X 10.7
  24. How to export a mysql database using Command Prompt?
  25. MySQL Error #1133 – Can’t find any matching row in the user table
  26. How can I prevent SQL injection in PHP?
  27. Best way to store an array in MySQL database?
  28. How do I change the data type for a column in MySQL?
  29. MySQL date formats – difficulty Inserting a date
  30. Cannot connect to Database server (mysql workbench)
  31. How to grant remote access permissions to mysql server for user?
  32. How to check if mysql database exists
  33. #1062 – Duplicate entry for key ‘PRIMARY’
  34. How can I convert a string to a float in mysql?
  35. Is there a Profiler equivalent for MySql?
  36. How to use greater than operator with date?
  37. How to properly create composite primary keys – MYSQL
  38. How to replace the domain name in a WordPress database?
  39. Optimize WordPress Query that take 5 seconds to execute
  40. MySQL Replication Latency Issues in wp-admin pages
  41. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  42. Increment value (value = value+1) of $wpdb->update
  43. How can I debug my database connection for unit testing?
  44. Extending the database
  45. SQL query not working in alphabetical post title/content search
  46. How can I manage my multiple wordpress websites from main website?
  47. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  48. How to do a MySQL dump from production site without using a search and replace script for local development?
  49. How to bulk edit canonical url’s in SQL?
  50. Replace existing pages with new pages, keep menu links
  51. Concurrent / simultaneous MySQL connections
  52. How to check for empty and not a failure
  53. What is the most secure way to set up the MySQL user in WPMU?
  54. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  55. Keeping database within limits, please help!
  56. Best settings for MySQL to speed up site? [closed]
  57. HTML Entities in Post Title
  58. Can’t find my wordpress DB in phpmyadmin
  59. Deprecated: mysql_connect():
  60. How are multiple WordPress WPDB queries handled?
  61. $wpdb select all meta for each post
  62. Calculate average crossing post categories
  63. Replacing link URL ending strings via MySQL
  64. Many slow queries post_type = ‘attachment’;
  65. SQL command to convert all tags in lowercase?
  66. Problem with admin login after deployment
  67. Find out how many times the user has logged in
  68. Is it possible to create a WordPress table using array and loop?
  69. Can’t run database query
  70. How to stop $wpdb from prepending database name
  71. Match tag names with form titles
  72. Error missing MySQL extension
  73. Getting Error Trying to Create Table
  74. Best approach for a custom database filling in WP custom post types
  75. Why doesn’t custom mysql query return results? Is syntax correct?
  76. Insert two row in wordpress database
  77. query_posts meta_key with current date
  78. SQL statement using placeholder is not returning results
  79. How to Bulk find and replace MySQL for post image url
  80. export and import wordpress customization
  81. Wpdb query with dynamic table name
  82. How to search usermeta table
  83. Regular XML-RPC timeouts
  84. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  85. update multiple rows in mysqli table base on two values
  86. How can I verify WordPress nonce from the following code?
  87. How to write in MySQL more characters in user_nicename
  88. $wpdb->get_var not returning count
  89. Custom user query – orderby meta_key (that may not exist)
  90. How to get Attachments(image) with specific width\height ratio
  91. What is the cron doing?
  92. Apache Redirect based on WordPress permissions
  93. SQL error on restoring database
  94. MySQL database gives blank page (white screen of death)
  95. Datatabase error: Commands out of sync
  96. why is $wpdb->update() causing a DB error from within wp_set_password()
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database