- vsprintf: documentation ( source)
<?php
echo vsprintf(
"UPDATE %s SET %s=REPLACE(%s, %s, %s) WHERE %s LIKE %s",
array('table',
'field_name',
'field_name',
'^from^',
'^to^',
'field_name',
'^from^')
);