Need SQL query to find&replace image URL

If you don’t have WPCLI installed, but still have commandline access or access via PHPMyAdmin, run:

UPDATE wp_posts SET post_content  = REPLACE(post_content,'<old URL>','<new URL>');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'<old URL>','<new URL>');

Related Posts:

  1. Setting up foreign keys in phpMyAdmin?
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL Error #1133 – Can’t find any matching row in the user table
  4. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  5. How to create a foreign key in phpmyadmin
  6. importing a CSV into phpmyadmin
  7. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  8. What specific database privileges does WordPress need?
  9. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  10. How to copy post titles to post slug in phpmyadmin
  11. How to do a MySQL dump from production site without using a search and replace script for local development?
  12. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  13. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  14. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  15. Can’t find my wordpress DB in phpmyadmin
  16. Backing up and restoring multiple sites efficiently
  17. $wpdb to insert html form information
  18. Setting up WordPress Locally on WAMP for a new site (with one already)
  19. Getting Error Trying to Create Table
  20. Export Yoast Keywords from MySQL/phpMyAdmin
  21. Editing mysql tables/database with wordpress or other app/cms
  22. List users with the most posts in the last 30 days
  23. Export SQL query based on custom field?
  24. Mysql Server keeps crashing
  25. How to bulk delete a certain part of all wordpress posts
  26. When I add metadata, metavalue length is added in to the value in some cases
  27. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  28. Find locations of all featured images of draft posts via SQL
  29. SQL query to change custom field in WordPress database
  30. An SQL query to find orphaned image attachments and their meta
  31. cannot log in to the mysql server (wamp and wordpress)
  32. SQL command to export post_content from wp_posts using phpMyAdmin
  33. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  34. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  35. MySQL Error “Operand should contain 1 column”
  36. How to use MySQL DECIMAL?
  37. MySQL ERROR 1290 (HY000) –secure-file-priv option
  38. MySQL server startup error ‘The server quit without updating PID file’
  39. Duplicating a MySQL table, indices, and data
  40. mysql Foreign key constraint is incorrectly formed error
  41. SELECT * FROM multiple tables. MySQL
  42. mysql: SOURCE error 2?
  43. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  44. MySQL foreach loop
  45. MySQL IF NOT NULL, then display 1, else display 0
  46. MySQL Calculate Percentage
  47. Repair all tables in one go
  48. Get the new record primary key ID from MySQL insert query?
  49. How to change collation of database, table, column?
  50. Failed building wheel for mysql-python
  51. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  52. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  53. Remove Primary Key in MySQL
  54. How to get the max of two values in MySQL?
  55. mysql: connection refused when trying to connect to localhost using remote IP
  56. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  57. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  58. Complex meta query with 3 keys
  59. How to log mysql errors from wordpress core?
  60. Gaining Login Access via the Database
  61. wpdb Custom Meta Data with 2 conditions
  62. query to create woocommerce products from images
  63. Configure WordPress to connect to Mysql DB using SSH tunneling
  64. Set Display Name to first and last name (phpmyadmin SQL Query)
  65. Rewrite database urls
  66. Migrating from Existing MySQL Setup to WordPress
  67. How to split the a table in database?
  68. How do I join a $wpdb query with user meta using default value if not exist?
  69. mySQL statment count of post in each category and sub category
  70. Paypal Post IPN handeling nightmare
  71. Is there a page length limit?
  72. WordPress tables and aliases?
  73. What’s the sql for this condition?
  74. Create a form with custom autocomplete address field and CSV import values
  75. WordPress insert query is not working : Showing no Error
  76. Copy usermeta value where ID matches in the same table
  77. Some Post Content Does Not Show Up In DB Search
  78. How can I write a formal sql query to get data from a custom table
  79. How can I view my site directly from WordPress dashboard?
  80. (WP List Table) How to sort by SKU and Custom Fields?
  81. Word Press and database from another server sync
  82. User set date and time from frontend doesn’t get stored into database
  83. get posts whether meta_key exists or not
  84. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  85. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  86. Changes not being reflected on new server
  87. update_option returns false in AJAX, how to debug?
  88. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  89. WordPress database error Duplicate entry for key ‘slug’
  90. MySQL – How to combine data from two tables into one?
  91. Check if a database is well installed
  92. Stop my loop to register data twice
  93. `#1215 – Cannot add foreign key constraint
  94. How to restore: Database intact but folders deleted
  95. wp_postmeta – lot of meta fields
  96. XML RPC post produces immediate revision with odd post_date_gmt
  97. Woocommerce: Grab total revenue of a product over all orders
  98. SQL Database Lost
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?