replaceq.php

<?php

$table = array(
    'Petru?' => 'Petruț',
    'Chi?in?u' => 'Chișinău',
    'Vulc?ne?ti' => 'Vulcănești',
    'hor?' => 'horă',
    'Vacan?a' => 'Vacanța',
    'Constan?a' => 'Constanța',
    'Buz?u' => 'Buzău',
    'Porti?ei' => 'Portiței',
    '?tefan' => 'Ștefan',
    'C?linescu' => 'Călinescu',
    'St?nescu' => 'Stănescu',
    'Costine?ti' => 'Costinești',
    'M?cin' => 'Măcin',
    'Br?ila' => 'Brăila',
    'C?t?lin' => 'Cătălin',
    'Y???lca' => 'Yığılca',
    'Alapl?' => 'Alaplı',
    'K?z?lay' => 'Kizalay',
    'Arde?en' => 'Ardeşen',
    'A?dam' => 'Ağdam',
    '??neada' => 'İğneada',
    '?skender' => 'İskender',
    'K?rklareli' => 'Kirklareli',
    'R?ze?ii' => 'Răzeșii',
    'Dub?sari' => 'Dubasari',
    'Costa?' => 'Costas',
    'Çaml?hem?in' => 'Çamlıhemşin',
    'Ç?ld?r' => 'Çıldır',
    'š?? All?h?' => 'In šāۥ Allāh?',
    'K?y?köy' => 'Kiyiköy',
    '???????? ???????????' => 'პატრიციუ …სირცხვილია'
);

$model = "UPDATE blogRecords SET content = REPLACE(content, '%s', '%s')
    WHERE INSTR(content, '%s') > 0;";
$query = "";
$i = 0;

foreach ($table as $key => $value) {
    $i++;
    $query .= "\n-- $i \n"
            . sprintf($model, $key, $value, $key);
}

echo $query;