Regular Expressions 101

Pro

^start of line

\d+a digit, repeated at least once

Character Class[\w-]+

+matches at least one character from the set below:

\wany word character

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

sqlthe literal text sql (case sensitive)

$end of line

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

^\d+[\w-]+\.sql$

2020_06_25_14_00-create-all-tables.sql
2020_06_26_13_55-create-table-bar.sql
2020_06_27_14_13-create-table-baz.sql
2020_06_27_15_20-alter-table-baz.sql
2020_06_27_18_00-create-table-foo.sql