regex101: JavaScript Match Workspace

Group 1(\(*)

\(*the literal ( (40₁₀ / 50₈ / 28₁₆) , repeated any number of times

Group 2([\w][\w\d.]*)

Character Class[\w]

\wany word character

Character Class[\w\d.]*

*matches any number of characters from the set below:

\wany word character

\da digit

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

\s*any whitespace character, repeated any number of times

Group 3([<>!=]{1,2}|like|not like|is null|is not null|in\s*\()?

?repeats the group contents below at most once:

1st Alternative[<>!=]{1,2}

Character Class[<>!=]{1,2}

{1,2}matches between 1 and 2 characters from the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

2nd Alternativelike

likethe literal text like (case sensitive)

3rd Alternativenot like

not likethe literal text not like (case sensitive)

4th Alternativeis null

is nullthe literal text is null (case sensitive)

5th Alternativeis not null

is not nullthe literal text is not null (case sensitive)

6th Alternativein\s*\(

inthe literal text in (case sensitive)

\s*any whitespace character, repeated any number of times

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

\s*any whitespace character, repeated any number of times

Negative Lookahead(?!and|or)

1st Alternativeand

andthe literal text and (case sensitive)

2nd Alternativeor

orthe literal text or (case sensitive)

Non-Capturing Group(?:(?:(between )(['"]?)(.*?)(\5)( and )(['"]?)(.*?)(\9))|(?:(['"]?)(.*?)(\12)))

1st Alternative(?:(between )(['"]?)(.*?)(\5)( and )(['"]?)(.*?)(\9))

Non-Capturing Group(?:(between )(['"]?)(.*?)(\5)( and )(['"]?)(.*?)(\9))

Group 4(between )

between the literal text between (case sensitive)

Group 5(['"]?)

Character Class['"]?

?matches at most one character from the set below:

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

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

Group 6(.*?)

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

Group 7(\5)

\5the text saved by group 5

Group 8( and )

and the literal text and (case sensitive)

Group 9(['"]?)

Character Class['"]?

Group 10(.*?)

Group 11(\9)

2nd Alternative(?:(['"]?)(.*?)(\12))

\s*any whitespace character, repeated any number of times

Group 15(\)*)

\s+any whitespace character, repeated at least once

Negative Lookahead(?!'|")

\s*any whitespace character, repeated any number of times

Group 16(and|or)?

\s*any whitespace character, repeated any number of times

Global pattern flags

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

Search reference

Regular Expression

(\(*)([\w][\w\d.]*)\s*([<>!=]{1,2}|like|not like|is null|is not null|in\s*\()?\s*(?!and|or)(?:(?:(between )(['"]?)(.*?)(\5)( and )(['"]?)(.*?)(\9))|(?:(['"]?)(.*?)(\12)))\s*(\)*)\s+(?!'|")\s*(and|or)?\s*

New

id between 3 and 10

Regular Expressions 101

Regular Expression

Extraction