MySQL Find and Replace Drupal filepaths in files table

Revision: 7304

at July 17, 2008 14:13 by shrop

Initial Code

update files set filepath = replace(filepath,'path/to/search','path/to/replace');

Initial URL

Initial Description

This is useful if you are changing a Drupal site's file upload path and/or changing from a private to a public file store.

Initial Title

MySQL Find and Replace Drupal filepaths in files table

Initial Tags

mysql, drupal

Initial Language

SQL