Online PHP editor | refs for rOQDG

@ 2019-07-12T09:09:31Z

<?php
$re = '/\) VALUES (.+?(?=\)))/m';
$str = 'INSERT INTO table (`col1`, `col2`, `col3`) VALUES (\'oneVal\', \'twoVal\', \'threeVal\')';
$subst = ',`col4`) VALUES $1 , \'1\'';

$result = preg_replace($re, $subst, $str);

echo $result;