Manual fix for broken image links via wysiwyg in drupal 6

While working on localhost, the path for wysiwyg images could be /sites/site_name/sites/default/files/img.jpg. But after uploading on to server, the image path could become /sites/all/default/files/img.jpg. To fix this path error manually, run the following query in the phpmyadmin sql.
UPDATE boxes SET body = replace( body, "/sites/site_name", "" )