Regular Expressions 101

Pro

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

Character Class[ \n]*?

*?matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

Group 1(select[ \n]*?max$[ \n].*?column_name[ \n]$[\D\d \n]+)

selectthe literal text select (case sensitive)

Character Class[ \n]*?

*?matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

maxthe literal text max (case sensitive)

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

Character Class[ \n]

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

.*?any character (except for line terminators), repeated any number of times

column_namethe literal text column_name (case sensitive)

Character Class[ \n]

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

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

Character Class[\D\d \n]+

+matches at least one character from the set below:

\Dany character that's not a digit

\da digit

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

Character Class[ \n]*?

*?matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

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

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

\([ \n]*?(select[ \n]*?max\([ \n].*?column_name[ \n]\)[\D\d \n]+)[ \n]*?\)

New

value = ( select max( tbl.column_name ) from table tbl where trim(colum2)='value1'
and (trim((colum3)))='value3')

value = ( select max( tbl.column_name ) from table tbl where trim(colum2)='value1'
and (trim((colum3)))='value3')