3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?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^') );
Output for 4.3.0 - 7.1.7
UPDATE table SET field_name=REPLACE(field_name, ^from^, ^to^) WHERE field_name LIKE ^from^