3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php echo vsprintf( "UPDATE %s SET %2s=REPLACE(%s, %s, %s) WHERE %s LIKE %s", array('table', 'field_name', 'field_name', '^from^', '^to^', 'field_name', '^from^') );
Output for 4.3.0 - 5.6.28, hhvm-3.10.0 - 3.13.2, 7.0.0 - 7.1.0
UPDATE table SET field_name=REPLACE(field_name, ^from^, ^to^) WHERE field_name LIKE ^from^