Davy's Blog

Mass Replace String use MySQL REPLACE function

Since i changed the path for a friend's blog, i need update the files and images path URL in all previous posts. The best way i found is use MySQL REPLACE function to replace string in hundreds of records. Only need 1 minute. Here is the SQL query to replace string in database table: [code] UPDATE table_name SET column_name = REPLACE(column_name,”original_string”,”replace_string”) [/code] SQL query for mass replace string in wordpress table [code] UPDATE `wp_posts` SET `post_cont...