Regular Expressions 101

1st Alternative^'\s*(SELECT)[^']*(FROM)[^']*'

^start of line

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

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

Group 1(SELECT)

SELECTthe literal text SELECT (case sensitive)

Negated Character Class[^']*

*matches any number of characters outside the set below:

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

Group 2(FROM)

FROMthe literal text FROM (case sensitive)

Negated Character Class[^']*

*matches any number of characters outside the set below:

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

2nd Alternative^"\s*(SELECT)[^"]*(FROM)[^"]*"

^start of line

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

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

Group 3(SELECT)

SELECTthe literal text SELECT (case sensitive)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

Group 4(FROM)

FROMthe literal text FROM (case sensitive)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

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

^'\s*(SELECT)[^']*(FROM)[^']*'|^"\s*(SELECT)[^"]*(FROM)[^"]*"

New

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

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

SELECT * FROM table