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