3v4l.org

run code in 300+ PHP versions simultaneously
<?php $query = "UPDATE `benefits` SET `ins_d`='6' WHERE `ben_id`='1'"; $sql_operators_arr = array("SET", "VALUES", "FROM", "WHERE", "LEFT JOIN", "RIGHT JOIN", "INNER JOIN", "OUTER JOIN", "JOIN", "GROUP BY", "ORDER BY", "LIMIT", "AND", "OR"); $vals = ""; foreach ($sql_operators_arr AS $val) { $re = "/(.*?)( )*(" . $val . ")(.*)/"; $subst = "$1\n$2$3$4"; $query = preg_replace($re,$subst,$query); } echo $query;
Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
UPDATE `benefits` SET `ins_d`='6' WHERE `ben_id`='1'

preferences:
225.81 ms | 404 KiB | 372 Q