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:
SQL query for mass replace string in wordpress table
