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:

UPDATE table_name SET column_name = REPLACE(column_name,”original_string”,”replace_string”)

SQL query for mass replace string in wordpress table

UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, 'liewcf.com/wp', 'liewcf.com/blog')
UPDATE `wp_posts` SET `guid` = REPLACE(`guid`, 'liewcf.com/wp', 'liewcf.com/blog')