regex101: PCRE (Legacy) Match Workspace

Non-Capturing Group(?:\G(?!\A),|SELECT)

1st Alternative\G(?!\A),

\Gstart of current search

Negative Lookahead(?!\A)

\Astart of string

,the literal , (44₁₀ / 54₈ / 2C₁₆)

2nd AlternativeSELECT

SELECTthe literal text SELECT (case sensitive)

Non-Capturing Group(?:\s+[^\s,]+(?:$[^()]*$)?,)*

*repeats the group contents below any number of times:

\s+any whitespace character, repeated at least once

Negated Character Class[^\s,]+

+matches at least one character outside the set below:

\sany whitespace character

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Non-Capturing Group(?:$[^()]*$)?

?repeats the group contents below at most once:

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

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

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

Negated Character Class[^\s,]+

+matches at least one character outside the set below:

\sany whitespace character

,the literal , (44₁₀ / 54₈ / 2C₁₆)

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

Non-Capturing Group(?:(?![()',])[[:punct:]]|AS)

1st Alternative(?![()',])[[:punct:]]

Negative Lookahead(?![()',])

Character Class[()',]

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Character Class[[:punct:]]

[:punct:]a punctuation character [!"#$%&'()*+,\-./:;<=>?@[\]^_`{|}~]

2nd AlternativeAS

ASthe literal text AS (case sensitive)

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

Non-Capturing Group(?:(?!FROM)[^,])*

*repeats the group contents below any number of times:

Negative Lookahead(?!FROM)

FROMthe literal text FROM (case sensitive)

Negated Character Class[^,]

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Negative Lookahead(?!\w)

\wany word character

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

Search reference

Regular Expression

(?:\G(?!\A),|SELECT)(?:\s+[^\s,]+(?:\([^()]*\))?,)*\s*\K[^\s,]+\s*(?:(?![()',])[[:punct:]]|AS)\s*(?:(?!FROM)[^,])*(?!\w)

New

SELECT col, col2 AS c2, col3, col * col2 calc FROM...
SELECT name, Concat(street, ' ', city, ', ', state, ' ', zipcode) AS address
SELECT name, Concat(street, ' ', city, ', ', state, ' ', zipcode), abc AS address