*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE offers ( id INT(11) UNSIGNED PRIMARY KEY, title VARCHAR(1400) NOT NULL, description TEXT NOT NULL ); CREATE TABLE offers_fixed ( id INT(11) UNSIGNED PRIMARY KEY, title VARCHAR(1400) NOT NULL, description TEXT NOT NULL ); INSERT INTO offers (id, title, description) VALUES (1, "AssisiOAssisifAssisifAssisirAssisiiAssisi AssisisAssisieAssisirAssisivAssisiiAssisizAssisiiAssisi AssisidAssisiiAssisi AssisitAssisirAssisiaAssisisAssisilAssisioAssisicAssisioAssisi AssisiaAssisi AssisiCAssisieAssisirAssisiiAssisigAssisinAssisioAssisilAssisiaAssisi AssisicAssisioAssisinAssisi AssisiEAssisirAssisinAssisieAssisisAssisitAssisioAssisi", ""), (2, "This title is good enough. Corsico.Still is good, Corsico.", "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormigineb."), (3, "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormiginebFormigine.", "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormiginebFormigine") ; SELECT * FROM offers;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php function replaceCities(string $data) { $pattern = '/((?<=[\w])Assisi|(?<=[ ])?Assisi(?![ \.,!?])|(?<=[\w])Corsico|Corsico(?![ \.,!?])|(?<=[\w])Formigine|Formigine(?![ \.,!?]))/m'; return preg_replace($pattern, '', $data); } $query = "SELECT id, title, description FROM offers;"; $result = $mysqli->query($query); $insertData = []; while ($row = mysqli_fetch_assoc($result)) { $insertData[] = [ 'id' => $row['id'], 'title' => replaceCities($row['title']), 'description' => replaceCities($row['description']), ]; } $stmt = $mysqli->prepare("INSERT INTO offers_fixed (id, title, description) VALUES (?,?,?)"); $stmt->bind_param("iss", $id, $title, $description); foreach($insertData as $row) { $id = $row['id']; $title = $row['title']; $description = $row['description']; $stmt->execute(); } $query = "SELECT id, title, description FROM offers_fixed;"; $result = $mysqli->query($query); while ($row = mysqli_fetch_assoc($result)) { var_dump($row); }

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online