$dbh->do(<<'GO');
UPDATE table_name
SET `fieldname`=REPLACE(`fieldname`,'‘','''')
GO