What SQL Query to do a simple find and replace

The table where your URL is saved is wp_options. You should do an update on the columns that use the URL for your site:

UPDATE TABLE wp_options SET option_value = "new domain" WHERE option_name = "siteurl"
UPDATE TABLE wp_options SET option_value = "new domain" WHERE option_name = "home"

I might be missing some value, but whenever you do this find/replace process again, you can notice the values and tables that should be updated and add them to this script.

WordPress Codex has a nice guide on how to change a site URL, maybe that’s even handier for you: Changing the Site URL

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  4. Cannot delete or update a parent row: a foreign key constraint fails
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. How do I restore a dump file from mysqldump?
  7. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  8. What does SQL Select symbol || mean?
  9. What is the definition of cardinality in SQL
  10. When to use SELECT … FOR UPDATE?
  11. Column ‘user_id’ in field list is ambiguous
  12. How to join two tables by multiple columns in SQL?
  13. mysql Foreign key constraint is incorrectly formed error
  14. Selecting data from two different tables without using joins
  15. 1052: Column ‘id’ in field list is ambiguous
  16. 1052: Column ‘id’ in field list is ambiguous
  17. MySQL: Invalid use of group function
  18. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  19. Simple Random Samples from a Sql database
  20. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  21. What does SQL clause “GROUP BY 1” mean?
  22. SQL ZOO List each continent and the name of the country that comes first alphabetically
  23. How can I prevent SQL injection in PHP?
  24. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  25. Generating a random & unique 8 character string using MySQL
  26. SQL select only rows with max value on a column
  27. SQL statement not working – “Operand type clash: date is incompatible with int’
  28. Convert partially non-numeric text into number in MySQL query
  29. Repair all tables in one go
  30. How can I search (case-insensitive) in a column using LIKE wildcard?
  31. #1062 – Duplicate entry for key ‘PRIMARY’
  32. How to do a batch insert in MySQL
  33. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  34. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  35. Remove Primary Key in MySQL
  36. Is merge statement available in MySQL
  37. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  38. How do you properly prepare a %LIKE% SQL statement?
  39. Is there a way to list all used/unused WP templates?
  40. Optimize WordPress Query that take 5 seconds to execute
  41. Scanning Database for malicious Data
  42. Optimize Multiple Taxonomy Term MySQL Query?
  43. wpdb->prepare function remove single quote for %s in SQL statment
  44. Multipart/formatted MySQL query problem
  45. What specific database privileges does WordPress need?
  46. Fulltext search in posts sorted by relevancy
  47. SQL query equivalent to WP User Query
  48. Extending the database
  49. How to find if a post with custom_field == X exists?
  50. Are database queries created using WordPress filters protected from SQL injection?
  51. Search and replace in post content
  52. Query WordPress database by registered date and role
  53. How to find meta entries with their posts missing via SQL?
  54. How do I see the mysql query generated by get_posts( $args )?
  55. Order by summing multiple values
  56. SQL Database, repeated tables?
  57. Include data from custom table in WP_Query
  58. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  59. WordPress Custom post query sorting does not work
  60. Code to remove authors with no posts connected to them
  61. Making a query to the DB using same parameters of loop
  62. Which is better and faster ? WordPress Queries or SQL Query
  63. SQL Query in WordPress – Getting Impossible WHERE error
  64. Custom SELECT Query With Multiple Meta Values (Ordering Problem)
  65. How to get INSERT errors from $wpdb?
  66. how to insert missing tags into the posts through mySQL?
  67. SQL query to set posts in bulk based on the post content
  68. MySQL query for taxonomy-meta
  69. How can I write a formal sql query to get data from a custom table
  70. mySQL queries are executed twice on wordpress website
  71. SQL query to get posts from multiple categories but not in a category
  72. latency problems with wordpress install (from SQL import)
  73. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  74. Lock wait timeout exceeded; try restarting transaction
  75. Find locations of all featured images of draft posts via SQL
  76. SQL query to change custom field in WordPress database
  77. SQL query to delete users with multiple meta keys and comments
  78. How to show result of sql query in a page?
  79. update_option returns false in AJAX, how to debug?
  80. Improving performance of SQL sub-queries in WordPress
  81. WPDB delivers wrong results from complex queries
  82. How to change link in all posts?
  83. Display MySQL as part of a Page
  84. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  85. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  86. Fastest and most efficient SQL query to check if UID exists
  87. How to make MySQL search queries with quotes
  88. Add commentmeta custom field to every published comment with SQL
  89. get_results() query not working only when entering strings
  90. SQL error on restoring database
  91. Query sql for truncate post_content in wp_posts table
  92. Custom WordPress SQL Query 4 posts per custom taxonomy
  93. Special Query: Title, Terms, Content – %LIKE%
  94. Woocommerce: Grab total revenue of a product over all orders
  95. Global MySQL replacing of text patterns/matches
  96. Delete posts with word count less than x number of words
  97. SQL – Pull products of particular category from a remote WordPress woocommerce db
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  100. SQL get last entry of a specific gravity form

Leave a Comment