regex101: PCRE (Legacy) Match Workspace

Group timestamp(?P<timestamp>[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}Z)

Character Class[0-9]{4}

{4}matches exactly 4 characters from the set below:

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

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

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

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

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

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

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

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

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

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

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

.any character (except for line terminators)

Character Class[0-9]{6}

{6}matches exactly 6 characters from the set below:

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

Zthe literal Z (90₁₀ / 132₈ / 5A₁₆) (case sensitive)

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

?optionally matches the literal (160₁₀ / 240₈ / A0₁₆)

Group connID(?P<connID>[0-9]+)

Character Class[0-9]+

+matches at least one character from the set below:

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

the literal (32₁₀ / 40₈ / 20₁₆)

Group name(?P<name>[a-zA-Z]+)

Character Class[a-zA-Z]+

+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)

the literal (32₁₀ / 40₈ / 20₁₆)

Group sqltext(?P<sqltext>[^\n]+)

Negated Character Class[^\n]+

+matches at least one character outside the set below:

\na line-feed (newline) character (ASCII 10)

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

(?P<timestamp>[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}Z) ? ? ? ? ? ?(?P<connID>[0-9]+) (?P<name>[a-zA-Z]+) (?P<sqltext>[^\n]+)

New

---my SQL--- 

2018-03-31T15:38:44.521650Z      2356 Query SELECT c FROM sbtest1 WHERE id=164802
2018-03-31T15:38:44.521790Z      2356 Query SELECT c FROM sbtest1 WHERE id BETWEEN 95241 AND 95340
2018-03-31T15:38:44.522168Z      2356 Query SELECT SUM(k) FROM sbtest1 WHERE id BETWEEN 1 AND 100
2018-03-31T15:38:44.522500Z      2356 Query SELECT c FROM sbtest1 WHERE id BETWEEN 304556 AND 304655 ORDER BY c
2018-03-31T15:38:44.522941Z      2356 Query SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 924 AND 1023 ORDER BY c
2018-03-31T15:38:44.523525Z      2356 Query UPDATE sbtest1 SET k=k+1 WHERE id=514