regex101: sql select request

^start of string

Group 1([s|S][e|E][l|L][e|E][c|C][t|T])

Character Class[s|S]

sthe literal s (115₁₀ / 163₈ / 73₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Sthe literal S (83₁₀ / 123₈ / 53₁₆) (case sensitive)

Character Class[e|E]

ethe literal e (101₁₀ / 145₈ / 65₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Ethe literal E (69₁₀ / 105₈ / 45₁₆) (case sensitive)

Character Class[l|L]

lthe literal l (108₁₀ / 154₈ / 6C₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Lthe literal L (76₁₀ / 114₈ / 4C₁₆) (case sensitive)

Character Class[e|E]

ethe literal e (101₁₀ / 145₈ / 65₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Ethe literal E (69₁₀ / 105₈ / 45₁₆) (case sensitive)

Character Class[c|C]

cthe literal c (99₁₀ / 143₈ / 63₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Cthe literal C (67₁₀ / 103₈ / 43₁₆) (case sensitive)

Character Class[t|T]

tthe literal t (116₁₀ / 164₈ / 74₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Tthe literal T (84₁₀ / 124₈ / 54₁₆) (case sensitive)

\sany whitespace character

Group 2([a-zA-Z0-9\-_]+|\*)

1st Alternative[a-zA-Z0-9\-_]+

Character Class[a-zA-Z0-9\-_]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

2nd Alternative\*

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

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

Group 3([a-zA-Z0-9\-_]+)*

*repeats the group contents below any number of times:

Character Class[a-zA-Z0-9\-_]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\sany whitespace character

Group 4([f|F][r|R][o|O][m|M])

Character Class[f|F]

fthe literal f (102₁₀ / 146₈ / 66₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Fthe literal F (70₁₀ / 106₈ / 46₁₆) (case sensitive)

Character Class[r|R]

rthe literal r (114₁₀ / 162₈ / 72₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Rthe literal R (82₁₀ / 122₈ / 52₁₆) (case sensitive)

Character Class[o|O]

othe literal o (111₁₀ / 157₈ / 6F₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Othe literal O (79₁₀ / 117₈ / 4F₁₆) (case sensitive)

Character Class[m|M]

mthe literal m (109₁₀ / 155₈ / 6D₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

Mthe literal M (77₁₀ / 115₈ / 4D₁₆) (case sensitive)

\sany whitespace character

Group 5([a-zA-Z0-9\-_]+)

Character Class[a-zA-Z0-9\-_]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

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

Group 6([a-zA-Z0-9\-_]+)*

*repeats the group contents below any number of times:

Character Class[a-zA-Z0-9\-_]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Group 7(.*)

.*any character (except for line terminators), repeated any number of times

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

$end of string, or before its final line terminator

Search reference

Regular Expression

^([s|S][e|E][l|L][e|E][c|C][t|T])\s([a-zA-Z0-9\-_]+|\*),?([a-zA-Z0-9\-_]+)*\s([f|F][r|R][o|O][m|M])\s([a-zA-Z0-9\-_]+),?([a-zA-Z0-9\-_]+)*(.*);$

New

SELECT * FROM foo WHERE;