WordPress for some reason didn’t use to filter out invalid file names on upload, causing some interesting issues with charsets and rendering (specifically images not loading in browsers).  Using the following queries, you can easily find those items with invalid filenames, and their associated posts (which unfortunately means you’ll still have to replace them)… SELECT ID, post_title, post_content, post_parent, guid FROM wp_posts WHERE post_type = ‘attachment’ AND `post_status` = ‘inherit’ AND (guid LIKE ‘%.jpg’ OR […]

DROP DATABASE `your_database_name`;

UPDATE yourtable SET this_field = REPLACE(this_field, ‘replace me’, ‘replacement value’);