Search and Replace MySQL

Performing a case-sensitive search-and-replace through a table is easy with MySQL when you know how.

UPDATE table_name SET table_field = REPLACE(table_field, 'replace_that', 'with_this');

This has proved useful for updating Drupal's files table where the paths are incorrect. I hope this helps someone