Find and replace in MYSQL

Updating Data in MYSql

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

For moving wordpress installs to repair the guid

UPDATE wp_posts SET guid = replace( guid, 'web/', '' ) ;