Regular Expressions 101

Explanation

Pro

SELECT the literal text SELECT (case sensitive)

Group 1(.*)

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

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

Non-Capturing Group(?:INTO (.*))

INTO the literal text INTO (case sensitive)

Group 2(.*)

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

\sany whitespace character

FROM the literal text FROM (case sensitive)

Group 3(.*)

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

Non-Capturing Group(?:\sWHERE (.*))

\sany whitespace character

WHERE the literal text WHERE (case sensitive)

Group 4(.*)

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

Non-Capturing Group(?:\sHAVING (.*))

\sany whitespace character

HAVING the literal text HAVING (case sensitive)

Group 5(.*)

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

Non-Capturing Group(?:\sORDER BY (.*))

\sany whitespace character

ORDER BY the literal text ORDER BY (case sensitive)

Group 6(.*)

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

SELECT (.*) (?:INTO (.*)).*\sFROM (.*)(?:\sWHERE (.*)).*(?:\sHAVING (.*)).*(?:\sORDER BY (.*)).*

New

SELECT test1.col1, test1.col2, test1.col3, "aaa" AS Error, x as y INTO test2
FROM test1, test3
WHERE (((test1.col2)="bbb") AND ((test1.col3) Is Null Or (test1.col3)="ccc"))
HAVING 1=1
ORDER BY 1;