Regular Expressions 101

Explanation

Pro

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Character Class[`\s]*

*matches any number of characters from the set below:

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

\sany whitespace character

Group 1([a-z0-9_\$]+)

Character Class[a-z0-9_\$]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

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

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Character Class[`\s]*

*matches any number of characters from the set below:

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

\sany whitespace character

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Character Class[`\s]*

*matches any number of characters from the set below:

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

\sany whitespace character

Group 2([a-z0-9_\$]+)

Character Class[a-z0-9_\$]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

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

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Character Class[`\s]*

*matches any number of characters from the set below:

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

\sany whitespace character

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

\([`\s]*([a-z0-9_\$]+)[`\s]*,[`\s]*([a-z0-9_\$]+)[`\s]*\)

New

UNIQUE INDEX `id` (`id`)
UNIQUE INDEX `name` (`name`,`id`)
UNIQUE INDEX test (trt,edw)
UNIQUE INDEX `test2`( `ewe` , wewe  )
UNIQUE INDEX `test2`( `ewe` , wewe, mary, stewe )

Extraction

UNIQUE INDEX `id` (`id`)
UNIQUE INDEX `name` (`name`,`id`)
UNIQUE INDEX test (trt,edw)
UNIQUE INDEX `test2`( `ewe` , wewe  )
UNIQUE INDEX `test2`( `ewe` , wewe, mary, stewe )