Вот собственно новая редакция рега: <? $some_string = " SET @idins = REPLACE(CONVERT(nvarchar(50), @myid), '-rrr'','dfj'njd' ) SET @userid = (SELECT ID FROM dbo.USERS WHERE (UserName = 'yuk'ko')) "; $string = preg_replace("/(?<=[\(=,]|<>)\s*('.*?')(?=\s*[,\\x29]|\s+where|\s*$|\s+and|\s+or)/sie","my_func('\\0')",$some_string); echo nl2br($string); function my_func($string) { $start = strpos($string,"'"); $end = strrpos($string, "'"); $begin = substr($string, 0, $start+1); $finish = substr($string, $end); $middle = substr($string, $start+1,$end-$start-1); $string = $begin.str_replace("'","''", $middle).$finish; return($string); } ?>
|