Regular Expressions 101

Atomic Group(?>[^;']|(?:''|(?>'(?:[^']|\\')*[^\\]')))+

+repeats the group contents below at least once:

1st Alternative[^;']

Negated Character Class[^;']

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

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

2nd Alternative(?:''|(?>'(?:[^']|\\')*[^\\]'))

Non-Capturing Group(?:''|(?>'(?:[^']|\\')*[^\\]'))

1st Alternative''

''the literal text ''

2nd Alternative(?>'(?:[^']|\\')*[^\\]')

Atomic Group(?>'(?:[^']|\\')*[^\\]')

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

Non-Capturing Group(?:[^']|\\')*

*repeats the group contents below any number of times:

1st Alternative[^']

Negated Character Class[^']

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

2nd Alternative\\'

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

Negated Character Class[^\\]

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

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

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

U modifier: Ungreedy. Quantifiers are lazy by default. A trailing ? makes a quantifier greedy

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?>[^;']|(?:''|(?>'(?:[^']|\\')*[^\\]')))+;

New

BEGIN;INSERT INTO TABLE_A (a, b, c) VALUES('42', '12', '\'ab\'c; DEF');INSERT INTO TABLE_B (d, e, f) VALUES('42', '43', 'XYZ ;uvw');COMMIT;select 'ds; ds\';da';

Regular Expression

Substitution