<?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