Regular Expressions 101

Pro

(?s)applies the following effective flags to the remainder of the pattern: gms

s modifier: single line. Allows a dot to match line terminators

Group 1(\"\"\"|\'\'\'|\"|\')

1st Alternative\"\"\"

\"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative\'\'\'

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

3rd Alternative\"

\"the literal " (34₁₀ / 42₈ / 22₁₆)

4th Alternative\'

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

Non-Capturing Group(?:\s*(SELECT)\s*\*\s*(SELECT|FROM))?

?repeats the group contents below at most once:

\s*a Unicode whitespace character, repeated any number of times

Group 2(SELECT)

SELECTthe literal text SELECT (case sensitive)

\s*a Unicode whitespace character, repeated any number of times

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

\s*a Unicode whitespace character, repeated any number of times

Group 3(SELECT|FROM)

1st AlternativeSELECT

SELECTthe literal text SELECT (case sensitive)

2nd AlternativeFROM

FROMthe literal text FROM (case sensitive)

Non-Capturing Group(?:(?<!\\)\\\1|.)*?

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

1st Alternative(?<!\\)\\\1

Negative Lookbehind(?<!\\)

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

\1the text saved by group 1

2nd Alternative.

.any Unicode character

\1the text saved by group 1

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.

25 tokens

(?s)(\"\"\"|\'\'\'|\"|\')(?:\s*(SELECT)\s*\*\s*(SELECT|FROM))?(?:(?<!\\)\\\1|.)*?\1

New

"SELECT * FROM table"
"
     SELECT * FROM table"

"""
Use this query here: "SELECT * FROM table"
"""

SELECT * FROM table