script to replace renamed wp images

UPDATE `wp_postmeta` SET `meta_value` = REPLACE( `meta_value` , '-1.jpg', '.jpg' ) WHERE `meta_value` LIKE ( '%-1.jpg' ) UPDATE tablename SET field_name = REPLACE(field_name , 'oldstring', 'newstring') WHERE field_name LIKE ('oldstring%');