Some of the stuff that I Google lots of times…
MySQL Find and Replace:
UPDATE tablename SET tablefield = replace(tablefield,”findstring”,”replacestring”);
You can add a WHERE clause onto this as well.
For example, here is one command a ran:
UPDATE `mos2_content` SET introtext = replace(introtext,”
“,””) WHERE `title` REGEXP ‘-0’;
JPEG Support in PIL: How to install Jpeg support for PIL, libjpeg on MacOSX? :