Regular Expressions 101

Pro

Negative Lookbehind(?<!\\)

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

Non-Capturing Group(?:\\{2})*+

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

\\{2}the literal \ (92₁₀ / 134₈ / 5C₁₆) , repeated exactly 2 times

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

`the literal ` (96₁₀ / 140₈ / 60₁₆)

Group 1((?:\\.|[^`\\])+)

Non-Capturing Group(?:\\.|[^`\\])+

+repeats the group contents below at least once:

1st Alternative\\.

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

.any character (except for line terminators)

2nd Alternative[^`\\]

Negated Character Class[^`\\]

`the literal ` (96₁₀ / 140₈ / 60₁₆)

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

`the literal ` (96₁₀ / 140₈ / 60₁₆)

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(?<!\\)(?:\\{2})*+\K`((?:\\.|[^`\\])+)`

New

-- MySQL syntax (backticks)
INNER JOIN `table_with_\`escaped` AS `x` ON ..
-- MSSQL syntax (square brackets)
INNER JOIN [table_with_\[escaped] AS [x] ON ..

Substitution

?database_name?.?${1}?

-- MySQL syntax (backticks)
INNER JOIN `table_with_\`escaped` AS `x` ON ..
-- MSSQL syntax (square brackets)
INNER JOIN [table_with_\[escaped] AS [x] ON ..