regex101: PCRE (Legacy) Match Workspace

Group 1(["'])

Character Class["']

"the literal " (34₁₀ / 42₈ / 22₁₆)

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

Non-Capturing Group(?:(?=(\\?))\2.)*?

*?repeats the group contents below any number of times:

Positive Lookahead(?=(\\?))

Group 2(\\?)

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

\2the text saved by group 2

.any character (except for line terminators)

\1the text saved by group 1

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

25 tokens

Regular Expression

(["'])(?:(?=(\\?))\2.)*?\1

New

UPDATE `wp_options` SET `option_value` = 'a:1151:{s:15:\"activ";}' WHERE `option_name` = 'my_options';

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

Extraction

UPDATE `wp_options` SET `option_value` = 'a:1151:{s:15:\"activ";}' WHERE `option_name` = 'my_options';

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');