Help for this page

Select Code to Download


  1. or download this
    $dbh->do(<<'GO');
UPDATE table_name
SET `fieldname`=REPLACE(`fieldname`,'‘','''')
GO
  2. or download this
    $dbh->do("UPDATE table_name SET `fieldname`=REPLACE(`fieldname`,'‘',''
+'')");
  3. or download this
    $dbh->do('UPDATE table_name SET `fieldname`=REPLACE(`fieldname`,\'‘\',
+\'\'\'\')');
  4. or download this
    $dbh->do(q(UPDATE table_name SET `fieldname`=REPLACE(`fieldname`,'‘','
+''')));