regex101: PCRE2 (PHP) Substitution Workspace

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

Group 1(\d{4})

\d{4}a digit, repeated exactly 4 times

Group 2(\d{2})

\d{2}a digit, repeated exactly 2 times

Group 3(\d{2})

\d{2}a digit, repeated exactly 2 times

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

Group 4(\d{2}:\d{2}:\d{2})

\d{2}a digit, repeated exactly 2 times

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

\d{2}a digit, repeated exactly 2 times

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

\d{2}a digit, repeated exactly 2 times

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

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

'(\d{4})(\d{2})(\d{2}) (\d{2}:\d{2}:\d{2})'

New

INSERT INTO table (field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field)
VALUES (1, '3110000000', 2, '21/01/2011 12:06', '1016', 1, 2, 'asdddasdsd', 'addasddadsd', 'adadadaddaddssaddaadddddddsadsd', 'asdasdsdsdadsadsadadasd', '06003160485', 'adadasdddaddadddds', '50124', 'asdsdaddad', 'asddasdadsad', '03321807576', NULL, '20110121 12:07:00', 1, NULL, NULL, 22),

Regular Expressions 101

Regular Expression

Extraction