Regular Expressions 101

Group 1(^ +| +$)

1st Alternative^ +

^start of line

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

2nd Alternative +$

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

$end of line

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(^ +| +$)

New

SELECT Test1,
           Test2, Test3 FROM Tabelle1 UNION 
 ALL SELECT * FROM Tabelle2    
 UNION SELECT * FROM Tabelle3