Regular Expressions 101

SETthe literal text SET (case sensitive)

Group 1((.|[\r\n\u2028\u2029])*?)

Group 2(.|[\r\n\u2028\u2029])*?

*?repeats the group contents below any number of times:

1st Alternative.

.any character (except for line terminators)

2nd Alternative[\r\n\u2028\u2029]

Character Class[\r\n\u2028\u2029]

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

\u2028the literal   (2028₁₆ / 20050₈ / 8232₁₀)

\u2029the literal   (2029₁₆ / 20051₈ / 8233₁₀)

WHEREthe literal text WHERE (case sensitive)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

SET((.|[\r\n\u2028\u2029])*?)WHERE

New

UPDATE pass
SET stato = -3, descr_stato = 'Scartata' WHERE pratica = '1458'
AND stato = 0
AND anno IN (2016, 2017, 2018);

UPDATE pass
SET stato = -3, descr_stato = 'Scartata'
WHERE pratica = '2383' AND stato = 0 AND anno IN (2020);

Regular Expression

Extraction