UPDATE tblemailtemplates_static SET message = REPLACE(message, "}.pdf", "}") WHERE message LIKE '%}.pdf%';
UPDATE tblemailtemplates SET message = REPLACE(message, "}.pdf", "}") WHERE message LIKE '%}.pdf%';