PHP Regular Expression Replace

[matthewo256]

I need a regex replace to escape the two single quotes after the @ sign.
If there is only one quote, do not replace.

$q = "INSERT INTO tablename(fields.....) VALUES('Y','Area of Study',10,1,'onChange@loadDegLevs(); log_fill('school');');"

$qNew = some_regex_function($q);

$qCorrect = "INSERT INTO tablename(fields.....) VALUES('Y','Area of Study',10,1,'onChange@loadDegLevs(); log_fill(\'school\');');";

echo $qNew."<hr>";
echo $qCorrect."<hr>";

[bradgrafelman]

Where is that data coming from? It'd probably just be easier to properly escape the data before it gets placed into the SQL query.

[matthewo256]

I agree 100%

The SQL comes from a gnarly bit of legacy code that I'd rather not rewrite..