##
$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`,'‘','''')));