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

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.

MySQL Find and Replace Drupal filepaths in files table

mysql, drupal

SQL