#include <MsgBoxConstants.au3> ; to declare the Constants of MsgBox
Local $sRegex = "SET((.|[\r\n\u2028\u2029])*?)WHERE"
Local $sString = "UPDATE pass" & @CRLF & _
"SET stato = -3, descr_stato = 'Scartata' WHERE pratica = '1458'" & @CRLF & _
"AND stato = 0" & @CRLF & _
"AND anno IN (2016, 2017, 2018);" & @CRLF & _
"" & @CRLF & _
"UPDATE pass" & @CRLF & _
"SET stato = -3, descr_stato = 'Scartata'" & @CRLF & _
"WHERE pratica = '2383' AND stato = 0 AND anno IN (2020);"
Local $sSubst = "WHERE"
Local $sResult = StringRegExpReplace($sString, $sRegex, $sSubst)
MsgBox($MB_SYSTEMMODAL, "Result", $sResult)
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for AutoIt, please visit: https://www.autoitscript.com/autoit3/docs/functions/StringRegExp.htm